KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
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
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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