Array constant in a SUMPRODUCT function needs to be converted to cell references

Hi everyone,

I have a simple formula as: =SUMPRODUCT(1*(A1:A100={1,2}))

But I want to make it more flexible rather than using the array constant {1,2}. Suppose I want to use cell C1 and C2 to store these two values of 1 and 2, and use C1 and C2 in the formula. How to achieve that?

One formula is something like: =SUMPRODUCT((A1:A100=C1)+(A1:A100=C2)). But this is still not neat enough. I prefer the use of brackets {} for this example

Thanks, Tony. It works nicely.

Regards