| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count, number of entries of a particular month.
Hi,
On Column A, say, rows A1:A100 has different dates. How can I count the number of rows that are dated for the month of April 2007? Please help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count, number of entries of a particular month.
One way:
=SUMPRODUCT(--(MONTH(A1:A100)=4),--(YEAR(A1:A100)=2007)) HTH, Paul "Danny" wrote in message ... Hi, On Column A, say, rows A1:A100 has different dates. How can I count the number of rows that are dated for the month of April 2007? Please help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count, number of entries of a particular month.
To count for the specific month *and* year:
=SUMPRODUCT(--(TEXT(A1:A100,"mmm yyyy")="Apr 2007")) To count for the month of *any* year: =SUMPRODUCT(--(MONTH(A1:A100)=4)) If there might be empty cells within the range and you want to count for the month of January then you need to add a test because empty cells will evaluate as month number 1: =SUMPRODUCT(--(ISNUMBER(A1:A100)),--(MONTH(A1:A100)=1)) Biff "Danny" wrote in message ... Hi, On Column A, say, rows A1:A100 has different dates. How can I count the number of rows that are dated for the month of April 2007? Please help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count, number of entries of a particular month.
Thanks a lot!
"T. Valko" wrote: To count for the specific month *and* year: =SUMPRODUCT(--(TEXT(A1:A100,"mmm yyyy")="Apr 2007")) To count for the month of *any* year: =SUMPRODUCT(--(MONTH(A1:A100)=4)) If there might be empty cells within the range and you want to count for the month of January then you need to add a test because empty cells will evaluate as month number 1: =SUMPRODUCT(--(ISNUMBER(A1:A100)),--(MONTH(A1:A100)=1)) Biff "Danny" wrote in message ... Hi, On Column A, say, rows A1:A100 has different dates. How can I count the number of rows that are dated for the month of April 2007? Please help. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count, number of entries of a particular month.
You're welcome!
Biff "Danny" wrote in message ... Thanks a lot! "T. Valko" wrote: To count for the specific month *and* year: =SUMPRODUCT(--(TEXT(A1:A100,"mmm yyyy")="Apr 2007")) To count for the month of *any* year: =SUMPRODUCT(--(MONTH(A1:A100)=4)) If there might be empty cells within the range and you want to count for the month of January then you need to add a test because empty cells will evaluate as month number 1: =SUMPRODUCT(--(ISNUMBER(A1:A100)),--(MONTH(A1:A100)=1)) Biff "Danny" wrote in message ... Hi, On Column A, say, rows A1:A100 has different dates. How can I count the number of rows that are dated for the month of April 2007? Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the number of date entries in a giving month | Excel Discussion (Misc queries) | |||
| How can I count the number of entries in a column? | New Users to Excel | |||
| Count number of different entries? | Excel Worksheet Functions | |||
| I Need to Count Number of Entries Based on Two Criteria | Excel Worksheet Functions | |||
| Count a numbers of entries in a given month ? | New Users to Excel | |||
Hybrid Mode
