I have the below spreadsheet, and I need it to automatically calculate totals when filtered, with multiple criteria on.
Basically: I am trying to get totals on column D for "NP", but only when column B is a unique value. I have a formula for that already:
=SUM(--(LEN(UNIQUE(FILTER(B2:B23,(D2:D23="NP"))))>0))
I just need it to only count the filtered values when I filter by date, rather than the whole thing. I have the sums doing that, and this is the formula I'm using for those:
=SUBTOTAL(109, O2:O23)
Any ideas/suggestions?
Basically: I am trying to get totals on column D for "NP", but only when column B is a unique value. I have a formula for that already:
=SUM(--(LEN(UNIQUE(FILTER(B2:B23,(D2:D23="NP"))))>0))
I just need it to only count the filtered values when I filter by date, rather than the whole thing. I have the sums doing that, and this is the formula I'm using for those:
=SUBTOTAL(109, O2:O23)
Any ideas/suggestions?