Calculate totals
Mike, use something like this,
=SUMIF(A1:A10,"bananas",B1:B10)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Mike Mike" wrote in message
...
This is what I got:
bananas 5 9 3 1
bananas 1 2 7 3
bananas 8 7 4 2
oranges 1 5 1 3
oranges 2 4 8 2
pears 9 5 2 3
pears 7 5 2 3 etc......
I need one row with the totals for each "fruit"
bananas 14 18 14 6
oranges 3 9 9 5
pears 16 10 4 6 etc...
Anyone know how to do this?
|