CountIF on Filtered data
 

I have a column of Data that I use a filter on to get desired records. In
some of the columns I have answers like A, B, C and I do a
COUNTIF(CELLRANGE, "A") and it works fine for the entire sheet. Is there a
way to get the countif only to count the items on the filter list.
Column 1 Column 2
Male A
Female A
Male A
Female A
Male B
Male B
Female B
Female B

So on the countif above I get 4 since 4 are A
When I do a filter for only Male, I would like the countif to show only 2
since there are only 2 males that selected A

Is there a way to do this? Any assistance would be appreciated.

CountIF on Filtered data
 

=SUMPRODUCT(SUBTOTAL(3,OFFSET(B1:B100,ROW(B1:B100 )-MIN(ROW(B1:B100 )),,1))*
(B1:B100="A"))

--
HTH

Bob Phillips

"Steadman" wrote in message
...
I have a column of Data that I use a filter on to get desired records. In
some of the columns I have answers like A, B, C and I do a
COUNTIF(CELLRANGE, "A") and it works fine for the entire sheet. Is there
a
way to get the countif only to count the items on the filter list.
Column 1 Column 2
Male A
Female A
Male A
Female A
Male B
Male B
Female B
Female B

So on the countif above I get 4 since 4 are A
When I do a filter for only Male, I would like the countif to show only 2
since there are only 2 males that selected A

Is there a way to do this? Any assistance would be appreciated.