Can COUNTIF work for multiple criteria??

  • Thread starter Thread starter MarianneR
  • Start date Start date
M

MarianneR

I am formatting a data sheet that will have data entered over time (each
will have a date). I'm trying to figure out how to 1) count the number
from a certain date range and 2) count the number of responses =4.

In point, my surveys will be entered over time. I already have a
function counting them by Month (e.g., Feb-04). I am trying to have
another column which will count the Excellent responses (4) during the
appropriate month.

I tried the countif function using "AND" and just couldn't make it
work.

Any help would be greatly appreciated!!

Marianne
 
Hi Marianne
COUNTIF accepts only one condition. You may use SUMPREODUCT. e.g.
if col. A stores your date and col B stores the response type (e.g. 4
for Excellent)
=SUMPRODUCT((A1:A100>=DATE(2004,1,1))*(A1:A100<DATE(2004,4,1))
counts the responses for the first quarter

=SUMPRODUCT((A1:A100>=DATE(2004,1,1))*(A1:A100<DATE(2004,4,1)*(B1:B100=
4)
counts the excellent responses for the first quarter
 
Back
Top