Hello,

I can use constants in SUMPRODUCT function, for example
SUMPRODUCT(...*(C100:C1000={"apples", "oranges'})*...), but I have troubles
when I am trying to use SUMPRODUCT with values from particular cells, for
example SUMPRODUCT(...*(C100:C1000={A1, A2})*...). Please help me with a
sysntacts I shoud use in my case. Thanks in advance!