Excel STOP COUNT/SUM on hidden rows
Posted on 2011-03-10
I have a list of assets that we filter.
Without changing how we filter and move data around....
I want to be able to show the count and sum of value for each asset in TOTAL as the filter changes.
I can get the right value with this:
=COUNT( IF(R_FilterType = "Desktop",1,0))
SUMIFS( R_filterType, "Desktop)
but It counts hidden rows as the filter does its work.
Is there a way to do it with subtotal or another approach.
Data would be:
Desktop A $100 div1
Laptop A $100 div2
Desktop B $100 div2
Desktop C #150 div2
Laptop D $120 div1