Totaling only filtered value on formula with multiple criteria

[goodomens]

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?

 

[SanjayGMusafir]

I'm so sorry, maybe I'm just not totally understanding, but this doesn't seem to work. I greatly appreciate you trying though!

You can try

=SUBTOTAL(102,A2:A23)

in totals row below and when you filter the above table manually it will give you the desired result. Try That.

 

[SanjayGMusafir]

I would use a helper column in P2 put this formula & fill down

=SUBTOTAL(103,B2)

Then you can use

=ROWS(UNIQUE(FILTER(B2:B23,(D2:D23="NP")*(P2:P23=1))))

I think that shall work, because it will only count visible cell in Column P

Rest the Unique and filter formula would do. Interesting.

Lets see if that works for querist or not.

 

[goodomens]

I would use a helper column in P2 put this formula & fill down

=SUBTOTAL(103,B2)

Then you can use

=ROWS(UNIQUE(FILTER(B2:B23,(D2:D23="NP")*(P2:P23=1))))

That worked. THANK YOU!

 

[Fluff]

Glad we could help & thanks for the feedback.