Subtracting

[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

 

[Guest]

=F4-SUM(F5:F12)

 

[Larry S]

=f4-sum(f5:f12)

 

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