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