excel Formula - sum only visible cells with multiple criteria

[RCBricker]

I found the following thread:

https://www.mrexcel.com/forum/excel-questions/995780-sumif-visible-cells-only.html

which is great and I love it, but I need to basically do a SUMIFS on visible cells. so How would I put that together?

Thanks,

 

[Fluff]

That's exactly what the formula you linked to does.

 

[Joe4]

Note that "SUMPRODUCT" was what we used to used to do "SUMIFS" before "SUMIFS" existed!
While SUMIFS exists now, there are still some more complex situations that will require you to use SUMPRODUCT instead.

Basically, any formula that you come up with using COUNTIF, COUNTIFS, SUMIF, or SUMIFS can also be done with SUMPRODUCT.
But SUMPRODUCT is more flexible, and can do more complex calculations.