Software

Ask something
Discussion Locked

Excel help, constant running total

0 helpful
3 replies

by james62

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need help with an inventory workbook our company has. We need it to have a running total of parts instock, and as we use the worksheet to input data, the inventory will change and then we have another sheet for output data that will tell us what parts we need or are short. The problem is we need to be able to do this process, clear the old entries, then start another job, but have the inventory counts to stay constant as they were changed from the last set of entries. Any thoughts.

Thanks,
Jim

3 replies

by zimonar

Suppose your values are in a range in column C. Enter the following formula for example:
In any cell in column D enter, =SUM(C:C)
- To keep a running total, you can enter your formula in any column, but not in the column that contain values. Any changes you do in values; edit or add new value(s), clear or delete cell(s)?, the cell total in another column is automatically updated.

by james62

This still doesn't keep the total when the input entries change, I have recently been told by several people that there is no way to get Excel to do this, and have suggested an Access inventory database. But if anyone knows of a formula that will allow a running total to stay the same even when the leading formulas change, please let me know.

Jim

This discussion is closed to new replies.