View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike Mike Mike is offline
external usenet poster
 
Posts: 7
Default Calculate totals

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?