The PRODUCT function
Multiplies all the numbers you give it, ranges included. Empty cells and text in a range are skipped.
Syntax
PRODUCT(number1, [number2], ...)- number1
- The first number, cell or range to multiply.
- number2, ... (optional)
- More numbers, cells or ranges, up to 255 in all.
Examples
D1=PRODUCT(B1:B3)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Length | 4 | 30 | |
| 2 | Width | 3 | ||
| 3 | Height | 2.5 |
E1
=PRODUCT(1A2,2B2,31-C2)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Price | Quantity | Discount | 90 | |
| 2 | 12.5 | 8 | 0.1 |
In plain words: Multiply 1the price in A2 by 2the quantity in B2 and by 3what is left after the discount in C2.
D1=PRODUCT(B2:B4)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Step | Factor | 24 | |
| 2 | One | 4 | ||
| 3 | Two | pending | ||
| 4 | Three | 6 |
Questions
Does PRODUCT treat an empty cell as zero?
No. PRODUCT skips empty cells and text in a range, so one empty cell does not turn the result into 0. A cell that holds 0 does.
Is PRODUCT the same as multiplying with *?
For a few cells, =A2*B2*C2 gives the same result. PRODUCT is shorter for long ranges, and it skips text where * returns