| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtract a range from an added range | Excel Discussion (Misc queries) | |||
| why cant i subtract one cell from another? | Excel Worksheet Functions | |||
| I need to subtract a range of numbers | Excel Worksheet Functions | |||
| subtract from numeric cell when alpha cell is occupied | Excel Worksheet Functions | |||
| Subtract Range Of Numbers using a Formula | Excel Discussion (Misc queries) | |||
Linear Mode
