Try

=SUMPRODUCT(--(YEAR(A5:A1000))=A1,E5:E1000)

HTH

Bob

"Mike 215" wrote in message
...
Hi,
I need to sum a colunm based on the date the cell entered.

A1 has a year, 2009
A5:A10000 has Dates, 01/02/2009
E5:E10000 Data to sum
E1 the sum of all Column E entered in 2009

Thanks for any help.