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))

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.

Ogandos

Please review the uploaded file.

It is the same that you originally created, but just testing the logic to confirm that it is what you need. (Look a second sheet called "Test", located at the bottom of the spreadsheet). You can also validate it with additional values from rows 2 to 9. C--Users-lfreund-Downloads-COST4--2.xlsm

LUIS FREUND

ASKER

Ah I see what is going on.....there is a formula at column M, how can I get this formula =SUMPRODUCT((M10:M688>H10:H688)*(M10:M688))