How can I use sumif or sumproduct functions under the filter mode?

[Bear]

Hi everyone

I have data in columns .. I need to use sumproduct or sumif functions and get the results for visible rows only
Is that possible by formulas?

Thanks!

 

[Luke M]

Hi Bear,

The trick is to create a helper column with a formula like:
=SUBTOTAL(103,A2)

Assuming there's something in A2, this formula result is 1 if the row is visible, and 0 if row is hidden. You can then include the helper column in your SUMIFS or SUMPRODUCT calculation as a criteria column.