|
wilkesboroguy
|
Posted 5:17 pm, 01/30/2010
|
Or, you can just put a "-" on those cells that are negative, then Sum the entire column.
|
|
wilkesman2
|
Posted 6:03 pm, 01/29/2010
|
=SUM(A1-A2-A3-A4-A5-A6-A7-A8-A9) or =SUM(A1-(A2+A3+A4+A5+A6+A7+A8+A9)) or =A1-SUM(A2:A23)
|
|
pumkin
|
Posted 4:37 pm, 01/29/2010
|
What if you wanted to subtract several cells do you do A1-A9
|
|
graybeard
|
Posted 2:29 pm, 01/28/2010
|
Using the sum function, enter the first cell, the enter a -, then enter the second cell.
Example: =SUM(A1-A2)
|
|
RedNeckHillBilly
|
Posted 7:56 am, 01/25/2010
|
To do this task, use the SUM function. Adding a negative number is the same as subtracting.
|
|
pumkin
|
Posted 5:20 pm, 01/24/2010
|
I can not figure out how to minus a #. I can do the total adding the lines, but can't for the life of me figure out how to subtract them. Thanks
|
|
|
