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

?B?R2xhZHlz?= wrote in
:

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


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

=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

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

Are you sure?

Try this

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

--

HTH

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


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