I need to keep a running inventory of pounds of rubber on hand, but want to do it in the same column. Is there a formula to total a range of cells, using both adding and subtracting. In other words can a cell contain a formula that will either add or subtract based on whether a plus or minus sign is used with the number, and the range of those cells automatically updates a cell at the top of the page with the total. Thank you.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Adding and subtracting in same cell range
- Thread starter kixeye1
- Start date
