I would like to add up values in a column, where another column value is
true,
for instance,

oranges = 5+6+2 = 13
pears = 2+3=5
apples = 9+6 = 15

Data:
Fruit Co Ltd 5 oranges
Fruits R us 2 pears
Fruity 6 apples
Tooty fruity 6 oranges
Fruit Co Ltd 2 oranges
Fruits R us 3 pears


--
hays4
------------------------------------------------------------------------
hays4's Profile: http://www.excelforum.com/member.php...o&userid=28069
View this thread: http://www.excelforum.com/showthread...hreadid=487203

Hava a look in help index for SUMIF

--
Don Guillett
SalesAid Software

"hays4" wrote in
message ...

I would like to add up values in a column, where another column value is
true,
for instance,

oranges = 5+6+2 = 13
pears = 2+3=5
apples = 9+6 = 15

Data:
Fruit Co Ltd 5 oranges
Fruits R us 2 pears
Fruity 6 apples
Tooty fruity 6 oranges
Fruit Co Ltd 2 oranges
Fruits R us 3 pears


--
hays4
------------------------------------------------------------------------
hays4's Profile:
http://www.excelforum.com/member.php...o&userid=28069
View this thread: http://www.excelforum.com/showthread...hreadid=487203