# Need help on multiple column Sumproduct Formula

#### LarryM13

##### New Member
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.

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:

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

#### Domenic

##### MrExcel MVP
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.

Last edited:

Replies
5
Views
611
Replies
4
Views
152
Replies
4
Views
406
Replies
1
Views
429
Replies
6
Views
239

1,195,687
Messages
6,011,152
Members
441,589
Latest member
tommatwalker

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back