Subtracting


G

Guest

Hello,

I was wondering how do you have column of numbers and subtract them. For
example the values I have in column "F" are my "Totals": $225.00, $32.09,
$16.27, $16.27, $19.48, $15.35, $44.69. $20.00, & $0.00. The range of cells
is "F4:F12. I want to place the formula in cell "F13". So, How do take cell
"F4" ($225.00) and subtract cells "F5:F12" ($32.09, $16.27, $16.27, $19.48,
$15.35, $44.69. $20.00, & $0.00) So that i can get the balance remaining
after those expenses?

Thanks
Josh
 
Ad

Advertisements

Ad

Advertisements

G

Guest

The other 2 solutions will work as well but an alternate is to enter the
value in cell F4 as a negative then Sum(f4-f12)
 

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


Top