# Excel Formula Help - SUMPRODUCT with Array of ID's

#### Johnny Thunder

##### Well-known Member
Hello All!

Not sure if this is possible but can I create a SUMPRODUCT formula that contains an array of ID's?

Below is the mock up of ID's that referece a Named Range "Cdata". This formula works if you duplicate and enter in a single ID (1256, 1261 ect.).

Any help is appreciated.

Formula: "=IFERROR(SUMPRODUCT((GData = 7840000) * (Cdata = {1256,1261,1265,1811}) * (IOHeader = \$B3) * (Hdata = K\$2) * DataTable) /1,0)"

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Eric W

##### MrExcel MVP
Try:

=IFERROR(SUMPRODUCT((GData = 7840000) * ISNUMBER(MATCH(Cdata,{1256,1261,1265,1811},0)) * (IOHeader = \$B3) * (Hdata = K\$2) * DataTable),0)

#### Johnny Thunder

##### Well-known Member
Worked like a charm! Thanks again Eric!

You're welcome!

Replies
1
Views
275
Replies
15
Views
1K
Replies
1
Views
386
Replies
4
Views
500
Replies
3
Views
239

1,132,910
Messages
5,655,902
Members
418,250
Latest member
Jebacmakro

### 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