Read Help to fins out about SUMIF then come back with any questions
OR learn about pivot tables (a bit more complicated)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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?