Help - Is it possible Formula

[Gladys]

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

 

[Dodo]

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.

Use SUMIF

 

[Bob Phillips]

=SUMIF(A1:A100,2005,B1;B100)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Paul]

One word of advice - make sure that the ranges are aligned (start and end on
the same row) or else you get funky data

 

[Bob Phillips]

Are you sure?

Try this

=SUMIF(A1:A100,2005,B2:B101)

--

HTH

RP
(remove nothere from the email address if mailing direct)