Sum value in all columns that their title is the same
 

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?

Sum value in all columns that their title is the same
 

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=9378A...121822A3%21326
for "SumIf2"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional