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" wrote:

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

--

HTH

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


"Gladys" wrote in message
...
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