excel countifs only filtered data

[bizzbuzz05]

Hi,

I have a Countifs function but I need it only to do filtered data. I have tried looking up how to do the "SUMPRODUCT" but cant get it to work.

Here is the Countifs =COUNTIFS(A7:A8000,"=Female",H7:H8000,"=Always").
How would I change it to the SUMPRODUCT or another function to count only filtered data?

Thanks
Bizzbuzz05

 

[Sufiyan97]

IFNA is to ignore #N/A Errors

 

[MrTwister85]

IFNA is to ignore #N/A Errors

can you please test your NA formula? its giving me VALUE error. Maybe it IFNA needs to be in very front?

=SUMPRODUCT(SUBTOTAL(103,OFFSET(W6,ROW(W6:W727)-ROW(W6),0,1)),--IFNA(W6:W727<>0,0))

 

[MrTwister85]