Countif with filter

[epnhakon]

I have results from a survey that I would like to count to present in a chart. When I use



=COUNTIF(B2:B21;"3")

that works fine.

But if I want to use Filter on column A, the =COUNTIF Function displays even the outfiltered results. How can I count the displayed results only?

Here is it in more detail:



So for example I would like to see how many "Male" have answered "3".

[Pecoflyer]

Perhaps

=SUMPRODUCT(SUBTOTAL(103,OFFSET(A2,ROW(A2:A100)-ROW(A2),0)),(A2:A100=3)+0)

Be careful not to use double quotes ("3") which is a string

[epnhakon]

I don't get this one to work. I tried it as you put it and also with "B" instead of "A" since I'm trying to count the numbers in column B.

I always get the count 0

[epnhakon]

disregard last post. This works perfectly.

Thanks for a quick reply @pecoflyer