Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home



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.

Re: Counting cells based on date.

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

==========


Re: Counting cells based on date.

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


Re: Counting cells based on date.

Posted by Aladin Akyurek on October 07, 2001 11:17 AM

Mark,

=SUM(Sheet1:Sheet30!C6)

should work.

Aladin




This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.