I'm trying to sum the data in "Tracked SKUs" columns I:T (represents Jan through Dec) with the criteria that column D in "Tracked SKUs" matches 'Plan Input'!A262
=SUMPRODUCT(--('Tracked SKUs'!$D:$D='Plan Input'!A262),'Tracked SKUs'!I:T)
I've also tried
=SUMPRODUCT(--('Tracked SKUs'!$D:$D='Plan Input'!A262),'Tracked SKUs'!I:I+'Tracked SKUs'!J:J+'Tracked SKUs'!K:K+'Tracked SKUs'!L:L+'Tracked SKUs'!M:M+'Tracked SKUs'!N:N+'Tracked SKUs'!O:O+'Tracked SKUs'!P:P+'Tracked SKUs'!Q:Q+'Tracked SKUs'!R:R+'Tracked SKUs'!S:S+'Tracked SKUs'!T:T)
I am getting an error stating that Excel has run out of resources for the first formula and #value for the second formula
Not sure what I am missing.
Thank you in advance!
Larry
I did use the below formula for January and it works fine
=SUMPRODUCT(--('Tracked SKUs'!$D:$D='Plan Input'!A262),'Tracked SKUs'!I:I)
=SUMPRODUCT(--('Tracked SKUs'!$D:$D='Plan Input'!A262),'Tracked SKUs'!I:T)
I've also tried
=SUMPRODUCT(--('Tracked SKUs'!$D:$D='Plan Input'!A262),'Tracked SKUs'!I:I+'Tracked SKUs'!J:J+'Tracked SKUs'!K:K+'Tracked SKUs'!L:L+'Tracked SKUs'!M:M+'Tracked SKUs'!N:N+'Tracked SKUs'!O:O+'Tracked SKUs'!P:P+'Tracked SKUs'!Q:Q+'Tracked SKUs'!R:R+'Tracked SKUs'!S:S+'Tracked SKUs'!T:T)
I am getting an error stating that Excel has run out of resources for the first formula and #value for the second formula
Not sure what I am missing.
Thank you in advance!
Larry
I did use the below formula for January and it works fine
=SUMPRODUCT(--('Tracked SKUs'!$D:$D='Plan Input'!A262),'Tracked SKUs'!I:I)
Last edited: