MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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