Hi Everyone

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

I think you are making it somewhat more complex than it needs to be.

Simplified example:

Sheet 'Forecast Entry'

Sheet 'SAP Upload'

The formula in B3 is:

=SUMPRODUCT(('Forecast Entry'!$A$2:$A$5='SAP Upload'!B$2)*('Forecast Entry'!$B$1:$D$1='SAP Upload'!$A3)*'Forecast Entry'!$B$2:$D$5)

copied down and across.



Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.


Question Info

Last updated March 11, 2021 Views 153 Applies to: