| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count nos. on 3 criteria | Excel Worksheet Functions | |||
| Count across worksheets with two criteria | Excel Worksheet Functions | |||
| Count If 3 Criteria Met | Excel Worksheet Functions | |||
| Count or Sum based on more than 1 criteria | Excel Worksheet Functions | |||
| Sum Count of Criteria Every 3rd Row | Excel Worksheet Functions | |||
Hybrid Mode
