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