Countif with filter

		Microsoft Office Forums > Microsoft Excel > Excel
Countif with filter

FAQ

Thread Tools

Display Modes

08-29-2014, 03:56 AM

epnhakon

Windows 7 64bit Countif with filter

Office 2013

Novice

Join Date: Aug 2014

Posts: 3

Countif with filter

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

Last edited by epnhakon; 08-29-2014 at 04:01 AM. Reason: inserted a image

Tags

countif, filter, solved

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using =countif formula with drop down box.	wchristner	Excel	0	02-19-2014 12:44 PM
COUNTIF Formula	teza2k06	Excel	3	02-13-2014 12:37 PM
Countif	hockeytown	Excel	3	01-05-2013 08:06 AM
Countif issue	Katy I	Excel	2	07-11-2012 06:30 AM
Countif with 2 criteria	ibrahimaa	Excel	3	05-23-2011 11:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:19 PM.