SUM
Description
SUM(value1, value2,...)
Input | value1: the first value to sum. value2: the second value to sum.
Type: number, cells containing numbers, logical values, text that can be parsed as numbers. |
Output | The sum of values.
Type: number. |
Examples
SUM(1) >> 1
SUM(1, "2") >> 3
SUM(1, "2", TRUE) >> 4
SUM(1, "2", FALSE) >> 3
If parameter p equals to 3 (string) and cell C5 contains text 4:
SUM(p,C5) >> 7
SUM(p,C5,) >> 7
If cell B8 contains a data column ([1,2,3], integer) while cell B9 contains a data column ([4,5,6], string)
SUM(B8,B9) >> 6
SUM(B8,B9,[7,8]) >> 21
COUNT
Description
COUNT(value1, value2,...)
Input | value1: the first value to be counted. value2 [optional]: the second value to be counted.
Type: number, string, logical value, cell or array. |
---|---|
Output | The total number of elements. For cells and arrays, elements inside are counted rather the cells and arrays themselves. Null values are not counted.
Type: number. |
Examples
If B14:F14 contains the following values:
B14 | C14 | D14 | E14 | F14 |
12 | text | =false | ARRAY(1,2,3) |
COUNT(1,2,B14) >> 3
COUNT(1,2,C14) >> 3
COUNT(1,2,D14) >> 3
COUNT(1,2,E14) >> 5
COUNT(1,2,B14:E14) >> 8
COUNT(1,2,F14) >> 2
AVERAGE
Description
COUNT(value1, value2,...)
Input | value1: the first value that participated in the operation. value2 [optional]: the second value that participated in the operation.
Type: number, string, logical value, cell or array. |
---|---|
Output | Sum up all number values and divide the sum by the total number of elements as the final output.
Type: number. |
Examples
If B23:F23 contains the following values:
B23 | C23 | D23 | E23 | F23 |
1 | text | ="1" | ="false" |
AVERAGE(1, B23) >> 1
AVERAGE(1,C23) >> 0.5
AVERAGE(1, D23) >> 1
Cells containing logical values or null values are eleminated before the operation:
AVERAGE(1, E23) >> 1
AVERAGE(1, F23) >> 1
AVERAGE(1,true) >> 1
In arrays, logical values are counted as elements while null values are not counted as elements:
AVERAGE(1,B23:E23) >> 0.6
AVERAGE(1,B23:F23) >> 0.6
CHAR
Please reference Text function
DATE
Please reference Date and time function.
MAX
Please reference Math and trig function.
MIN
Please reference Math and trig function.
TIME
Please reference Date and time function.
RANGE
Description
RANGE(start_value, stop_value, step)
Input | start_value [optional]: the start value of the numbers to be generated.
stop_value: the stop value of the numbers to be generated.
step [optional]: the difference between the latter number and the former number.
Type: interger. |
---|---|
Output | Genarate a sequence of numbers ranging between the start_value and the stop_value and the next number increment by step each time. If only pass 2 parameters, they are recognized as start_value and stop_value, and the default value of step is 1 in this case. If only pass 1 parameter, it is recognized as stop_value, the default values of start_value and step are 1 in this time.
Type: array containing intergers. |
Examples
RANGE(1,100,20) >> 1,21,41,61,81
RANGE(0,5) >> 0,1,2,3,4,5
RANGE(5,0,-2) >> 5,3,1
RANGE(5) >> 1,2,3,4,5