need help with SUMPRODUCT

  • Thread starter Thread starter Alexey
  • Start date Start date
A

Alexey

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:A2,FALSE))))*....)

HTH,
Bernie
MS Excel MVP
 
Thanks Bernie, it works!

Bernie Deitrick said:
Alexey,

This will work:

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

HTH,
Bernie
MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT in VBA 3
SumProduct in VBA 9
sumproduct with three criteria 8
multiple sumproducts and now formula is too long 3
SUMPRODUCT on an entire column? 2
Excel Help with wildcard and sumproduct 1
Count cells containing text, multiple criteria 2
Sumproduct not counting if the formula result is zero 1

Back
Top