# Sumproduct not working on existing sheet

I'm adding up the cost that is less than the base cost.  On the attachment on column M is less than column H then I want to sum all that up.  The formula I'm using does not work for some reason and I'm getting a #value error.

At cell M693 I have this formula:  =SUMPRODUCT((M10:M688<H10:H688)*(M10:M688))

Any ideas on how to fix this?
Ogandos

membership
Create an account to see this answer
Signing up is free. No credit card required.
LUIS FREUND

AWESOME!!!  Thank you!

I just noticed that it actually summed up everything in the column.  So it's not really working......
Hey Luis,

What is the desired behavior? Could you describe briefly the logic that you need?

I wanted to add up all the cost per row that is less than the baseline cost.  So in this case if the cost at column M is less than the cost of column H then add that up.  See below

Base Total Cost              SSVFC Cost
\$1000                               \$500
\$5000                               \$10000
\$2000                               \$1000

So  the value I want is \$1500 (\$500 + \$1000) since those cost is less than the base cost.