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

Using SUM(INDIRECT()) 2
subtract one cell from each cell in a range and count instances 2
Auto Sum not working correctly 1
Sumif apllying to all sheets in workbook 2
Need to find a static value in a cell and then subtract from adjacent cell 1
excel 2003 subtract function 3
Index, match, multiple IFs query 9
Formula not working 0

Top