Thread
:
Counting Rows by Month
View Single Post
#
5
Posted to microsoft.public.excel.newusers
R.VENKATARAMAN
Posts: n/a
Counting Rows by Month
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
Reply With Quote