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.

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.

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.

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.

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.