Subtotal on SumIf

S

Steven

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.
 
P

Peo Sjoblom

here is a method

=SUMPRODUCT(--($A$2:$A$100>5),--(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
 
Top