Counting Rows by Month

  • Thread starter Thread starter rgoubet
  • Start date Start date
R

rgoubet

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
 
to count
=SUMPRODUCT((MONTH(ChecksA)=1)*1)
to sum d for month 1
=SUMPRODUCT((MONTH(ChecksA)=1)*ChecksD)
 
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)

===============================
 
Back
Top