Counting Rows by Month

Hi,

I have a large table with ~2500 rows. One column contains date
information (date of the creation of the record).

I'd like to count how many records (rows) I have for each month. I
tried with the countif() function, but I don't know how to express a
date range in the criteria field.

Thanks in advance for your help.

Raph

Hi

One way
=COUNTIF(A1:A2500,"=01/11/2005")-COUNTIF(A1:A2500,"30/11/2005")
for the month of November
Or if you want to put your start and end dates in separate cells so you can
amend them, then with start date in D1 and end date in E1

=COUNTIF(A1:A2500,"="&D1)-COUNTIF(A1:A2500,""&E1)

Format the cell with the formula as General.

Regards

Roger Govier


wrote:
Hi,

I have a large table with ~2500 rows. One column contains date
information (date of the creation of the record).

I'd like to count how many records (rows) I have for each month. I
tried with the countif() function, but I don't know how to express a
date range in the criteria field.

Thanks in advance for your help.

Raph

to count
=SUMPRODUCT((MONTH(ChecksA)=1)*1)
to sum d for month 1
=SUMPRODUCT((MONTH(ChecksA)=1)*ChecksD)

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
Hi,

I have a large table with ~2500 rows. One column contains date
information (date of the creation of the record).

I'd like to count how many records (rows) I have for each month. I
tried with the countif() function, but I don't know how to express a
date range in the criteria field.

Thanks in advance for your help.

Raph

Wrote:
Hi,

I have a large table with ~2500 rows. One column contains date
information (date of the creation of the record).

I'd like to count how many records (rows) I have for each month. I
tried with the countif() function, but I don't know how to express a
date range in the criteria field.

Thanks in advance for your help.

Raph

Hi Raph

Try adding a helper column into which you paste the dates, then format
the dates as mmm, and then do countif


--
Paul S

there may be easier ways
what I would do
your first date is A1
in B1 type
=month(a1)
copy down all the 2500rows in column B
if you want to count for the month of November which is 11
empty cell type

=COUNTIF(B1:B2000,11)

===============================
"Paul S" wrote in message
...

Wrote:
Hi,

I have a large table with ~2500 rows. One column contains date
information (date of the creation of the record).

I'd like to count how many records (rows) I have for each month. I
tried with the countif() function, but I don't know how to express a
date range in the criteria field.

Thanks in advance for your help.

Raph

Hi Raph

Try adding a helper column into which you paste the dates, then format
the dates as mmm, and then do countif


--
Paul S

Excellent! Thanks everyone for your help!

Raph

Excellent, thanks everyone!

Raph