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.
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$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
"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.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks