Excel Formula Help - SUMPRODUCT with Array of ID's

[Johnny Thunder]

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)"

 

[Eric W]

Try:

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

 

[Johnny Thunder]

Worked like a charm! Thanks again Eric!

 

[Eric W]

You're welcome!