count using criteria
 

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

count using criteria
 

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

count using criteria
 

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

"Max" wrote:

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

count using criteria
 

Alternatively
=SUMPRODUCT((MONTH(A1:A6)=1)*(MONTH(A1:A6)<=3)*(B 1:B6="y"))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ferde" wrote in message
...
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

count using criteria
 

You're welcome, ferde.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ferde" wrote in message
...
THANK YOU SOOOO MUCH.... you answered my prayers !!