Autocalculate
If I understand you correctly you seem to be asking about functions.
When you select cells, Autocalculate might give you the SUM for example.
Say you select callse A1 through A5, you could type this in a cell as:
=SUM(A1:A5)
and this will display the sum of that range of cells.
In the same way you can use MIN, MAX,COUNT and AVERAGE.
These will update if you change the contents of the cells used for the
calculation. If you want to move these valuse, or freeze them (stop it being
a function) you can copy the cells, and 'Paste Special' just the values.
|