prod
Syntax:
Value
Number
prod
(
Range
source)
Description:
Multiplies together all numeric cells in
source
.
Examples:
($d1:$d3) = prod($a:$c)
Before:
A
B
C
D
1
1
6
7
2
2
5
8
3
3
4
20
4
5
6
After:
A
B
C
D
1
1
6
7
42
2
2
5
8
80
3
3
4
20
240
4
5
6
($a1) = prod($b1:$d20)