Counting Rows by Month

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
 
R

Roger Govier

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
 
D

Don Guillett

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

Paul S

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
Click to expand...

Hi Raph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
How to count the numbers in a Word document? 0
Need Help with a VBA subroutine 0
Need help with using Month as criteria for SUM(COUNTIFS(... 3
Using <= in countifs statement 1
Merging from an Excel file with graphics 1
Copy previous record into form field 0
Automation of scanned file storage based on content 0

Top