Subtracting
 

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

Subtracting
 

=F4-SUM(F5:F12)

"Josh Davis" wrote:

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

Subtracting
 

=f4-sum(f5:f12)

"Josh Davis" wrote in message
...
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

Subtracting
 

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)

"Larry S" wrote:

=f4-sum(f5:f12)

"Josh Davis" wrote in message
...
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