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".

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

disregard last post. This works perfectly.

Thanks for a quick reply @pecoflyer