Need help on multiple column Sumproduct Formula

[LarryM13]

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)

 

[Domenic]

Try using the "star" syntax, instead of the "comma" syntax...

=SUMPRODUCT(('Tracked SKUs'!$D2:$D100='Plan Input'!A262)*('Tracked SKUs'!I2:T100))

Alternative, try the following formula that needs to be confirmed with CONTROL+SHIFT+ENTER, and should be a bit more efficient...

=SUM(IF('Tracked SKUs'!$D2:$D100='Plan Input'!A262,'Tracked SKUs'!I2:T100))

Adjust the ranges, accordingly. If the ranges will increase over time, use dynamic named ranges instead of whole column references. The references will automatically adjust as data is added/removed.