SUMIF with INDEX

[dluhut]

Hello,

I have the following scenario

	ID	Jan	Feb	Mar
1	ID1	100	100	100
2
3	IDx	...	...	...
4	ID1	150	200	250

I'm trying to use the SUMIF with INDEX to SUM all the ID that are the same from Jan-Mar column.

Currently I have the following formula but is not working.

Please Login or Register  to view this content.

Note that $G:$R is Jan - Mar and $A:$A is column ID in this example

[dluhut]

I was able to resolve this by using sumproduct function.

Please Login or Register  to view this content.