trying to subtract a range from a cell
 

I have a gross pay minus four deductions all in currency.
My formula looked something like this: =sum(f3-(sumf4:f7)) which doesn't
work. I tried a few variations without success and the "help" doesn't help.
I'm using Excel, but I don't know which version.

trying to subtract a range from a cell
 

Try this =F3-SUM(F4:F6)

your original formula would also work you are just missing a (

=SUM(F3-SUM(F4:F7))

If this helps, please remeber to click yes

"Angel Woman" wrote:

I have a gross pay minus four deductions all in currency.
My formula looked something like this: =sum(f3-(sumf4:f7)) which doesn't
work. I tried a few variations without success and the "help" doesn't help.
I'm using Excel, but I don't know which version.