SUMIF, INDEX & MATCH Used Together

[mgeiss]

Hello,

I'm trying to create a sumif formula in which I can select the "Sum Range" based on a particular cell (Let's say E3). What I'm trying to do is create a Data Validation List so that you can select from the options available in E3. I was thinking an INDEX and MATCH combo would work for this. I want to look up the name in E3 using an INDEX formula. The name in E3 should be in A3:Z3 of the 2018 Budget tab. When i check my values, its not summing the total?

Any ideas?

=IFERROR(SUMIF('2018 Budget'!$A:$A,$C4,INDEX('2018 Budget'!$A$3:$Z$3,0,MATCH('Variance Lookup'!$E$3,'2018 Budget'!$A$3:$Z$3,0))),)

 

[Aladin Akyurek]

Try something like

=SUMIFS(INDEX('2018 Budget'!$A:$Z,0,MATCH($E$3,'2018 Budget'!$A$3:$Z$3,0)),'2018 Budget'!$A:$A,$C4)

assuming that both E3 and C4 are in the sheet where the formula is run.

 

[mgeiss]

I tried that, but my results is the same. Does the INDEX & MATCH formula look correct?

 

[Aladin Akyurek]

I tried that, but my results is the same. Does the INDEX & MATCH formula look correct?

Please try again...

What does this return?

=MATCH($E$3,'2018 Budget'!$A$3:$Z$3,0)