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!

Alexey,

This will work:

=SUMPRODUCT(...*(NOT(ISERROR(MATCH(C100:C1000,A1:A 2,FALSE))))*....)

HTH,
Bernie
MS Excel MVP


"Alexey" wrote in message
...
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!

Thanks Bernie, it works!

"Bernie Deitrick" wrote:

Alexey,

This will work:

=SUMPRODUCT(...*(NOT(ISERROR(MATCH(C100:C1000,A1:A 2,FALSE))))*....)

HTH,
Bernie
MS Excel MVP


"Alexey" wrote in message
...
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!