Dies ist die alte 4D Dokumentations-Website. Die neue und aktualisierte Dokumentation finden Sie unter developer.4d.com
- 4D View Pro Handbuch
-
- Formeln in 4D View Pro
-
-
Operatoren und Werte
-
Zellenreferenzen
-
Formeln vom Plug-In 4D View konvertieren
-
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
-
SUM
| SUM ( value {, value2 , ... , valueN} ) | ||||||||
| Parameter | Typ | Beschreibung | ||||||
| value | Zahl, CellRef |
|
Number(s) to be added together | |||||
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.
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
Produkt: 4D
Thema: Formeln in 4D View Pro
4D View Pro Handbuch ( 4D v19)
