SUM INDEX MATCH returning first instance

[adrienne0914]

Hi all,

I'm hoping you can help me out. I have a question about SUM INDEX MATCH for items in a row:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]PPTD[/TD]
[TD]PPTD[/TD]
[TD]PTD[/TD]
[TD]PTD[/TD]
[TD]PTD[/TD]
[TD][/TD]
[TD]PTD[/TD]
[TD]PPTD[/TD]
[/TR]
[TR]
[TD]Customers[/TD]
[TD]70[/TD]
[TD]81[/TD]
[TD]80[/TD]
[TD]94[/TD]
[TD]75[/TD]
[TD][/TD]
[TD]249[/TD]
[TD]151[/TD]
[/TR]
</tbody>[/TABLE]

The last two columns should total the others if there is a match to the column heading:

=SUM(INDEX($B2:$F2,MATCH(H$1,$B1:$F$1,0)))

Instead of returning the total for PTD, it just returns the first instance. What am I doing wrong?

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[TD]

I​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD][/TD]
[TD]PPTD[/TD]
[TD]PPTD[/TD]
[TD]PTD[/TD]
[TD]PTD[/TD]
[TD]PTD[/TD]
[TD][/TD]
[TD]PTD[/TD]
[TD]PPTD[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Customers[/TD]
[TD]

70​

[/TD]
[TD]

81​

[/TD]
[TD]

80​

[/TD]
[TD]

94​

[/TD]
[TD]

75​

[/TD]
[TD][/TD]
[TD]

249​

[/TD]
[TD]

151​

[/TD]
[/TR]
</tbody>[/TABLE]

H2=SUMIF($B$1:$F$1,H$1,$B$2:$F$2) copy across

 

[adrienne0914]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[TD]

I​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD][/TD]
[TD]PPTD[/TD]
[TD]PPTD[/TD]
[TD]PTD[/TD]
[TD]PTD[/TD]
[TD]PTD[/TD]
[TD][/TD]
[TD]PTD[/TD]
[TD]PPTD[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Customers[/TD]
[TD]

70​

[/TD]
[TD]

81​

[/TD]
[TD]

80​

[/TD]
[TD]

94​

[/TD]
[TD]

75​

[/TD]
[TD][/TD]
[TD]

249​

[/TD]
[TD]

151​

[/TD]
[/TR]
</tbody>[/TABLE]

H2=SUMIF($B$1:$F$1,H$1,$B$2:$F$2) copy across

Thank you so much! I guess I was overcomplicating things.

 

[MARZIOTULLIO]

You are welcome