count using criteria

[Guest]

Newbie ...please help. I would like to count all of the yes responses using a
date criteria so that the final results give me all the yes responses by
quarter. Example would be Jan-Mar = 1st quarter = 2 . Thank you

Admit Yes/NO
1/1/2007 y
2/22/2007 n
3/10/2007 y
4/6/2007 y
4/13/2007 n
5/2/2007 y

 

[Guest]

One way ..

Assuming data as posted within A1:B7,
put in say, C1:
=SUMPRODUCT((A2:A7>=--"1-Jan-2007")*(A2:A7<=--"31-Mar-2007")*(B2:B7="y"))

 

[Guest]

THANK YOU SOOOO MUCH.... you answered my prayers !!

 

[Bernard Liengme]

Alternatively
=SUMPRODUCT((MONTH(A1:A6)>=1)*(MONTH(A1:A6)<=3)*(B1:B6="y"))
best wishes

 

[Max]

You're welcome, ferde.