Counting cells based on date.
Posted by Mark Roberts on October 06, 2001 10:41 PM
I'm pretty new to Excel and would like to know how I can count a cell based on the date. I'm wanting to count cells with dates based on the month. Something like COUNTIF(C1:C10,">09/30/01")&(C1:c10,"<11/01/01") Thank you for any help.
Posted by Aladin Akyurek on October 06, 2001 11:39 PM
Mark,
Try:
=SUMPRODUCT((C1:C10>D1)*(C1:C10 < D2))
where D1 houses 09/30/01 and D2 11/01/01.
Aladin
==========
Posted by Mark Roberts on October 07, 2001 10:33 AM
Thanks! Worked great. Another question. I've got 30 pages and would like to take numbers from each and add them up on a different page. How do I identify each page. Say a number in C6 on each one. Thanks again....
Mark
Posted by Aladin Akyurek on October 07, 2001 11:17 AM
Mark,
=SUM(Sheet1:Sheet30!C6)
should work.
Aladin
