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
Bookmarks