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"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ferde" wrote:
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