Subtotal on SumIf
 

Can you use subtotal on a sumif or maybe some other method so when data is
filtered it calculates correctly. I have tried many things but cannot make
it work.

here is a method

=SUMPRODUCT(--($A$2:$A$1005),--(SUBTOTAL(3,OFFSET($A$2,ROW($A$2:$A$100)-MIN(ROW($A$2:$A$100)),,))),$A$2:$A$100)

this will sum all visible entries in A2:A100 that are greater than 5
where for instance column B could have been filtered



Regards,

Peo Sjoblom

"Steven" wrote:

Can you use subtotal on a sumif or maybe some other method so when data is
filtered it calculates correctly. I have tried many things but cannot make
it work.