H
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
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