G
Gerry Duggan
I am trying to set up a table that will sum values as they
enetered into cells. I thought that if I inserted a
formula into a cell that this would perform the
calculation. The only thing I can get it to do is to
perform the calculation once. If I change any of the
values in the data cells the total does not change in the
cell where the formula has been inserted. I have to
renenterthe cell to get a new total if any of the original
values are changed.
Is ther any way of setting up a formula in a cell that
will autimatically caluclate the result as values are
added and/or changed?
Would appreciate any suggestions.
Gerry
enetered into cells. I thought that if I inserted a
formula into a cell that this would perform the
calculation. The only thing I can get it to do is to
perform the calculation once. If I change any of the
values in the data cells the total does not change in the
cell where the formula has been inserted. I have to
renenterthe cell to get a new total if any of the original
values are changed.
Is ther any way of setting up a formula in a cell that
will autimatically caluclate the result as values are
added and/or changed?
Would appreciate any suggestions.
Gerry