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