trying to subtract a range from a cell

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

Paul C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtract one cell from each cell in a range and count instances 2
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
excel 2003 subtract function 2
need to subtract one cell from each cell in a row 1
Formula in a cell to calc FUTA tax 9
subtract a single cell from range of cells and then count 8
Nameing a function 1
Trying to either hide data in a cell or reduce the data to zero 2

Top