Isn't that just

=SUMIF(ARRAY,A1,ARRAY2SUM)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JM" wrote in message
m...
Here's the deal: I know SUMPRODUCT is capable of comparing multiple
values
against an array by using {}'s like this:

Cell A1: SUMPRODUCT((ARRAY={Option1,Option2,Option3})*ARRAY 2SUM)

BUT can the criteria range be made to reference a cell value??? Something
like this:

Cell A1: SUMPRODUCT((ARRAY={A2})*ARRAY2SUM)
Cell A2: "Option1,Option2,Option3"

This would be soooo helpful if possible.

Thanks in advance.

-- John