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:

	PPTD	PPTD	PTD	PTD	PTD		PTD	PPTD
Customers	70	81	80	94	75		249	151

<tbody>
</tbody>

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]

	A​	B​	C​	D​	E​	F​	G​	H​	I​
1​		PPTD	PPTD	PTD	PTD	PTD		PTD	PPTD
2​	Customers	70​	81​	80​	94​	75​		249​	151​

<tbody>
</tbody>

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

 

[adrienne0914]

	A​	B​	C​	D​	E​	F​	G​	H​	I​
1​		PPTD	PPTD	PTD	PTD	PTD		PTD	PPTD
2​	Customers	70​	81​	80​	94​	75​		249​	151​

<tbody>
</tbody>

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