| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell total plus and minus amounts
Is there a formula that you can total all of the + or - in one cell? For
example if the cell shows =+5-3-8+9 what is the formula that would add the + totals and would equal 14? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell total plus and minus amounts
There isn't a formula to do that (to the best of my knowledge)... If those
individual values were in seperate cells then it would be relatively straight forward with a simple sumif, but in the current form you are up the creek... -- HTH... Jim Thomlinson "Terry" wrote: Is there a formula that you can total all of the + or - in one cell? For example if the cell shows =+5-3-8+9 what is the formula that would add the + totals and would equal 14? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell total plus and minus amounts
Oh well, thought I'd ask.
Thanks! "Jim Thomlinson" wrote: There isn't a formula to do that (to the best of my knowledge)... If those individual values were in seperate cells then it would be relatively straight forward with a simple sumif, but in the current form you are up the creek... -- HTH... Jim Thomlinson "Terry" wrote: Is there a formula that you can total all of the + or - in one cell? For example if the cell shows =+5-3-8+9 what is the formula that would add the + totals and would equal 14? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to total the amounts between certain dates | Excel Discussion (Misc queries) | |||
| get a runing total for"curent date"or(cell)minus prev 30 days( cel | Excel Worksheet Functions | |||
| how to total amounts in one colum | Excel Worksheet Functions | |||
| Is it possible to get a sub-total of amounts when... | Excel Discussion (Misc queries) | |||
| Linking total amounts | Excel Worksheet Functions | |||
Hybrid Mode
