Sumif filtered rows only

[goodomens]

Hello, me again! You all were very helpful over the weekend so hoping you can help me with this as well.

I've hidden some rows, but here is my spreadsheet:

I need to be able to:
- Calculate the sum of Gross Revenue (K)
- But only when D = NP
- And I need it to calculate only visible rows, so that if I filter by a date, it will only show results for that date.

Can anyone help?

 

[Domenic]

Try...

=SUMPRODUCT(--(D2:D11="NP"),SUBTOTAL(9,OFFSET(K2:K11,ROW(K2:K11)-ROW(K2),0,1)))

Hope this helps!

 

[goodomens]

Try...

=SUMPRODUCT(--(D2:D11="NP"),SUBTOTAL(9,OFFSET(K2:K11,ROW(K2:K11)-ROW(K2),0,1)))

Hope this helps!

That worked, thank you so much!!

 

[Domenic]

You're very welcome, glad I could help.

Cheers!