How to SUMIF only Visible Cells In Excel
SUMIF Data Ignoring Hidden Rows in Excel is not as simple as other types of summation using criteria.
This is because the SUMIF function does not ignore hidden rows.
The solution comes from using a combination of SUBTOTAL & OFFSET functions to return only visible rows