I am looking for a SUMIF for a INDEX MATCH MATCH Formula
In the Target sheet i have Vendors on Rows and Months/Year on Colms.
The INDEX MATCH MATCH formula gives me the result i want for one single period but for the same vendor i want to add up all these number for the same period. So if the Vendor item comes up again in the Colm. again then i need a total for the Period in one single cell for that particular Vendor
I am using below formula but of no use. It is not doing SUMIF
=SUMIF('Forecast Entry'!$AT$117:$AT$177,IFERROR(INDEX('Forecast Entry'!$AT$117:$BZ$177,MATCH('SAP Upload'!S$19,'Forecast Entry'!$F$117:$F$177,0),MATCH('SAP Upload'!$B52,'Forecast Entry'!$AT$1:$BZ$1,0)),0),'Forecast Entry'!$AT$117:$BZ$177)
I have tried to add a picture of both the sheets above. IN the result (2nd pic) it should have added 50 + 333 for Datacom Vendor for Dec '20.
Please let me know if someone can help sumif and tell me how to correct it so it adds up