Forum Discussion
Self Calculation
Hi, Since some time, i trying to do this. But, i haven't found any solution for this. The problem is, i want excel to add the value when i enter a value in that cell. for example, a cell has...
Although it is possible, I would not recommend doing that. You'd have no way to know what contributed to the end result, so no way to correct errors.
I'd enter the values in a column, each value in its own cell. In a cell elsewhere, use the SUM function to add up the values. That will allow you to inspect and if necessary correct the values.