If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Counting cells with specific date ranges
How would I count cells within specific date ranges? For
example, if I have a column of cells that have different dates in them, how would I count the number of cells that have a September date, an October date, and so on? COUNTIF doesn't seem to like it when I try to use it with date ranges. Thanks in advance if someone can help with this. |
#2
|
|||
|
|||
Counting cells with specific date ranges
Dino, try this =SUMPRODUCT((MONTH(A1:A100)=9)+0) will count the dates that
= Sept. -- Paul B Always backup your data before trying something new Using Excel 97 & 2000 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "Dino" wrote in message ... How would I count cells within specific date ranges? For example, if I have a column of cells that have different dates in them, how would I count the number of cells that have a September date, an October date, and so on? COUNTIF doesn't seem to like it when I try to use it with date ranges. Thanks in advance if someone can help with this. |
Thread Tools | |
Display Modes | |
|
|