sum
Syntax:
Value
Number
sum
(
Range
source)
Description:
Adds up the numeric values in
source
.
Examples:
($d1:$d4) = sum($a:$c)
Before:
A
B
C
D
1
1
4
7
2
2
5
8
3
3
6
9
4
5
6
After:
A
B
C
D
1
1
4
7
12
2
2
5
8
15
3
3
6
9
18
4
5
6
($a1) = sum($b1:$d20)