Sum of Alternate Columns

[LalitPandey87]

Hi

In J3 with Ctrl + Shift + Enter

=SUMIF(OFFSET($D$2,0,0,1,MAX(IF($D$2:$IV$2 = $D$2, COLUMN($D$2:$IV$2 ),0))-2),$D$2,OFFSET($D$2,ROWS($J$3:$J3),0,1,MAX(IF($D$2 :$IV$2 = $D$2, COLUMN($D$2:$IV$2 ),0))-2))

In K3 with Ctrl + Shift + Enter

=SUMIF(OFFSET($D$2,0,0,1,MAX(IF($D$2:$IV$2 = $E$2, COLUMN($D$2:$IV$2 ),0))-2),$E$2,OFFSET($D$2,ROWS($K$3:$K3),0,1,MAX(IF($D$2 :$IV$2 = $E$2, COLUMN($D$2:$IV$2 ),0))-2))

Tried with inserting new column in between and its working.

[msiyab]

Worked like a charm! Thank you

Hi

In J3 with Ctrl + Shift + Enter

=SUMIF(OFFSET($D$2,0,0,1,MAX(IF($D$2:$IV$2 = $D$2, COLUMN($D$2:$IV$2 ),0))-2),$D$2,OFFSET($D$2,ROWS($J$3:$J3),0,1,MAX(IF($D$2 :$IV$2 = $D$2, COLUMN($D$2:$IV$2 ),0))-2))

In K3 with Ctrl + Shift + Enter

=SUMIF(OFFSET($D$2,0,0,1,MAX(IF($D$2:$IV$2 = $E$2, COLUMN($D$2:$IV$2 ),0))-2),$E$2,OFFSET($D$2,ROWS($K$3:$K3),0,1,MAX(IF($D$2 :$IV$2 = $E$2, COLUMN($D$2:$IV$2 ),0))-2))

Tried with inserting new column in between and its working.