This is a thinker: Sumproduct with Index/Match

[Wannabepro]

Hi Everyone,

So this is my equation

{=IFERROR(SUMPRODUCT(--('1'!$A$5:$A$33='Monthly'!A2), INDEX('1'!$N$5:$N$33,,MATCH('Monthly'!A2, '1'!$A$5:$A$33, 0))),"")}
{=IFERROR(SUMPRODUCT(--('1'!$A$5:$A$33='Monthly'!A3), INDEX('1'!$N$5:$N$33,,MATCH('Monthly'!A3, '1'!$A$5:$A$33, 0))),"")}

It is taking a group of people who work and ads their pay. The problem I am coming across is that it will only add the first person's pay and only if I put them in the first line A5. If I put that same person in subsequent cells it ads them just fine but if I start them in say A6 or further it will not add them at all. In addition this should be adding different names as it goes down the list but it will only take the one name if any. That is what the 'Monthly'!A2, A3 is for. To select a different name.

Any help would be appreciated!

 

[Aladin Akyurek]

Thank you soooooo much!!! The equation worked... I think I was doing the sumif incorrectly. =SUMIFS('1'!N:N,'1'!A:A,$A2) and your visual brought it all together! I love you all

You are welcome. Great that you liked it.