To compute the sum, average, minimum or maximum value of a range of cells:

1. Double-click a cell


2. Type "=" (equal sign) followed by the function you want to use (SUM, AVERAGE, MIN or MAX).
   i.e. '=SUM'


3. At this point you need to define the set of cells the calculations will apply to:
   - for a range of cells, you should enter, between parenthesis, the starting cell and the ending cell of the range, separated by a colon:
   "=SUM(A1:Z1)" for example, will compute the sum of all the cells between A1 and Z1.

- for several non-contiguous cells, you should enter , between parenthesis, all the cells references, separated by semicolons:
"=AVERAGE(A1;B1;C1)" for example, will compute the average of cell A1, B1 and C1.

For more information on functions, please see the 4D View user reference located at:

4D View 6.8 User Reference