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
=SUMPRODUCT((C1:C10>D1)*(C1:C10 < D2))
where D1 houses 09/30/01 and D2 11/01/01.
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....
Re: Counting cells based on date.Posted by Aladin Akyurek on October 07, 2001 11:17 AM
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.