# Excel multiple cell subtraction

Discussion in 'Business Applications' started by HeroicAge, Aug 18, 2013.

Not open for further replies.

Joined:
Aug 18, 2013
Messages:
2
I've uploaded a test file for you to look at.

If you look at the file you will notice I have cell C17 as a totals cell for C4:C16. I would like to have an additional cell F17 to show me the remaining balance to be paid. But I need this to lower based on an x in a D cell by the corresponding C cells value.

So basically F17 should show 626 to start. An "x" in D5 lowers the amount by C5's value which is 191 making F17's value 435. Adding another "x" in D6 would lower it by an additional 96 making the value 339. So on and so forth.

I hope I explained that well enough. Can anyone help?

File size:
12 KB
Views:
35
2. ### XCubed

Joined:
Feb 21, 2013
Messages:
520
Hi
See if this does the trick ...

=SUM(C4:C16)-SUMIF(\$D\$4:\$D\$16,"x",\$C\$4:\$C\$16)

or just

=SUMIF(\$D\$4:\$D\$16,"",\$C\$4:\$C\$16)

Joined:
Aug 18, 2013
Messages:
2
=SUM(C4:C16)-SUMIF(\$D\$4:\$D\$16,"x",\$C\$4:\$C\$16) works great for me. The other one worked also, but with this one I'll be able to keep a running total over several months easier I think. Thank you.

As Seen On