Can COUNTIF work for multiple criteria??

[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

 

[Frank Kabel]

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