SUM

This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

4D View Pro Reference
- 4D View Pro Formulas
- - Operators and values
  - Cell references
  - Converting 4D View plug-in formulas
  - ABS
  - ACOS
  - AND
  - ASIN
  - ATAN
  - AVERAGE
  - COLUMNLETTER
  - COS
  - COUNTA
  - EXP
  - FALSE
  - FINDCELL
  - FV
  - IF
  - INDIRECT
  - ISBLANK
  - LEN
  - LN
  - LOOKUP
  - MAX
  - MID
  - MIN
  - NOT
  - NOW
  - NPER
  - OR
  - PI
  - PMT
  - PV
  - RAND
  - RATE
  - ROUND
  - ROW
  - RUNTIME_CURRENT_TIME
  - RUNTIME_DATE
  - RUNTIME_STRING
  - RUNTIME_TIME
  - RUNTIME_VIEW_STRING
  - SIN
  - SQRT
  - STDEV.P
  - SUBSTITUTE
  - SUM
  - TAN
  - TEXT
  - TODAY
  - TRUE
  - TYPE
  - VAR.P

Home

4D v19

4D View Pro Reference

4D View Pro Formulas

SUM


SUM ( value {, value2 , ... , valueN} )

Parameter	Type	Description
value	Number, CellRef	Number(s) to be added together

Description

The SUM function returns the sum of cells or range of cells.

In value, pass the values to evaluate. Each argument can be a number, or an array of numbers (a single array (cell range) or multiple arrays (cell ranges)).

Note: The + operator provides an auto-conversion for non-numeric values passed by constant and for non-numeric values passed by reference. The SUM function provides an auto-conversion for non-numeric values passed by constant but, ignores non-numeric values passed by reference.

Example

SUM(A1,B7,C11)
  SUM(A1:A9)
  SUM(A2:A14,B2:B18,D12:D30)

SUM(95,89,73,87,85,76,100,96,96) //797

PROPERTIES

Product: 4D
Theme: 4D View Pro Formulas

PAGE CONTENTS

Description

Example

HISTORY

ARTICLE USAGE

4D View Pro Reference ( 4D v19)

Add a comment