Try this

=SUMIF(F1:F20,2004,G1:G20)

Mike

"MarkW1307" wrote:

Hi,
I have found some functions similar to what i need but nothing that hits the
spot and would appreciate any help.
I have data in a number of sheets which contains date references and data
entries associated. All sheets are a standardisd layout.
Col F Col G
2004 2.4
2005 2.5
2005 3.5
2004 12.6
2005 16.5
2004 21
2006 15
I would like to create a formula which adds up the data by year for each
diferent year ie.
2004 2.4, 2004 12.6, 2004 21
2005 2.5, 2005 3.5, 2005 16.6
2006 15
Which i can then extract into another sheet

I look froward to any response.
Thanks