Entries per year

[onebodaciousbabe03]

I have a spreadsheet with a column for date. I would like to use a function
that will tell me how many entries there are per year. I have the dates
entered as 7/29/2009, etc. I can't seem to get it right. Any ideas? Thanks
in advance!

 

[Shane Devenshire]

Hi,

Suppose your dates are in column A then enter the year in G1, say 2009 and
then use

=SUMPRODUCT(--(YEAR(A1:A28)=G1))

 

[smartin]

I have a spreadsheet with a column for date. I would like to use a function
that will tell me how many entries there are per year. I have the dates
entered as 7/29/2009, etc. I can't seem to get it right. Any ideas? Thanks
in advance!

A few ways...

This regular worksheet function will count how many dates are in 2009:

=SUMPRODUCT(--(YEAR(A1:A999)=2009))


This array* formula will do the same:

=SUM(IF(YEAR(A1:A999)=2009,1))


This array* formula will count the date years for all the years
indicated. It must be entered into a range of vertical cells (4 high, in
this case) at once:

=FREQUENCY(YEAR(A1:A999),{2007,2008,2009,2010})


*Commit the array formulas by pressing Ctrl+Shift+Enter, not just Enter
or Tab.