I have a spreadsheet with following info -

Column A - Column B
2004 10.00
2005 11.00
2005 15.00
2004 5.00
Total 2005 26.00 (b2+b3)

I would like a formula in cell b5 that adds data in column "B if the data in
column "A" = 2005
So in this example the formula in total 2005 should equal 26.00.

Hope this makes sense - Thanks in advance - This is a large spreadsheet and
if this is possible it would make life a lot easier.
BTW using Excel 2003