trying to subtract a range from a cell

  • Thread starter Thread starter Angel Woman
  • Start date Start date
A

Angel Woman

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.
 
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
 
Back
Top