Excel Formula Help - SUMPRODUCT with Array of ID's

Johnny Thunder

Well-known Member
Joined
Apr 9, 2010
Messages
566
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

MrExcel MVP
Joined
Aug 18, 2015
Messages
8,784
Try:

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

Forum statistics

Threads
1,077,687
Messages
5,335,662
Members
399,033
Latest member
thefinu

Some videos you may like

This Week's Hot Topics

Top