View Single Post
  #1  
Old October 10th, 2007, 01:23 PM posted to microsoft.public.excel.worksheet.functions
davor
external usenet poster
 
Posts: 2
Default "Conditional" sum

Please help. I have "input" data like this:

AA BB AA DD CC
--------------------------------------------------------------
8 10 8 8 8
10 10 10 10 8
12 8 7 12 8


Is it possible to have "output" data, summarizing all numbers for AA,
BB, CC... etc., something like this:
AA 55
BB 28
CC 24
DD 30

I have lot's of AA BB CCs and lots of values for them. If there is
some usefull formula please help me!
Thank you in advance!