Conditional SUMMING

[hays4]

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

[Don Guillett]

Hava a look in help index for SUMIF

--
Don Guillett
SalesAid Software
[email protected]
"hays4" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>