Thread
:
Counting number of incidents of a month
View Single Post
#
3
Don Guillett
Posts: n/a
Counting number of incidents of a month
Have a look in help index for COUNTIF and MONTH
--
Don Guillett
SalesAid Software
"CD Web" wrote in message
...
I have a spreadsheet that has one named range 'DATE' which contains a date
in the format 01-MAR-05.
I have a summary sheet that I have each month listed in 12 cells (Jan to
Dec).
I want to read the DATE range, and count the number of occurances which
fall
into each month.
Is this possible with a Excel funtion, or mixture of functions, or do I
need
to write my own?
Thanks for any help.
Regards
Chris Darlington
Reply With Quote