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!

try:
=SUMPRODUCT((A1:C1="AA")*A2:C4)

HTH
Sebation.G
"davor"
roups.com...
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!

Assume source "input" data as posted is within A1:E4,
with top row headers: AA, BB, AA, etc

Assume the headers are listed in G1 down: AA,BB,CC, etc

Put in H1:
=SUMPRODUCT(--ISNUMBER(MATCH($A$1:$E$1,G1,0))*$A$2:$E$4)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"davor" wrote in message
ups.com...
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!

On 10 list, 14:51, "Sebation" wrote:
try:
=SUMPRODUCT((A1:C1="AA")*A2:C4)

HTH
Sebation.G

Thank you, that is IT!!!
Thank you alot!