Sum value in all columns that their title is the same

[Duy Huynh]

I have a given data set:

S1 S1 S2 S2 S2 S3
Type A 1 3 6 7 2 2
Type B 4 4 5 3 1 2
Type C 5 4 3 2 2 3


And below is my table:

Item Type Step TOTAL
Item 1 Type A S1
Item 2 Type B S2
Item 3 Type C S3

I want to sum the total of all the same step in above table based on the condition of Type and Step in below table. How to do that?

 

[Claus Busch]

Hi,

Am Wed, 4 Jun 2014 08:51:39 -0700 (PDT) schrieb Duy Huynh:

I have a given data set:

S1 S1 S2 S2 S2 S3
Type A 1 3 6 7 2 2
Type B 4 4 5 3 1 2
Type C 5 4 3 2 2 3

And below is my table:

Item Type Step TOTAL
Item 1 Type A S1
Item 2 Type B S2
Item 3 Type C S3

please have a look:
https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for "SumIf2"


Regards
Claus B.