Tech Tip: How to get the sum, average, minimum or maximum value of a range of cells

PRODUCT: 4D View | VERSION: 2003 | PLATFORM: Mac & Win

Published On: May 30, 2003

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

- Double-click a cell
- Type "=" (equal sign) followed by the function you want to use (SUM, AVERAGE, MIN or MAX).

i.e. '=SUM' - 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