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.