Functions for calculating products
There are two ways to calculate a product: with the “*” sign (=A1*B1*C1) or with the PRODUCT function. PRODUCT(number1, number2, …) multiplies the arguments or all the numbers in a range and ignores empty and text cells in the range: for 1.5, 2, 4, 0.5 in A1:A4, =PRODUCT(A1:A4) = 6. When the range is long, the function shortens the entry and is easy to keep when a new row is added. SUMPRODUCT(array1, array2) multiplies matching cells and adds the products; it is useful for calculating an order total with one formula. A factorial can be written PRODUCT(1, 2, …, n) or FACT(n). SUM is used for a sum and PRODUCT for a product; do not mix them up.
A sports coach awards points for exercises: each exercise has points per repetition, and the number of repetitions differs. Instead of multiplying each exercise and then adding, the coach uses a single function. The total comes out in one step.
Warehouse staff, accountants and order packers find the sum of price-times-quantity pairs this way.
For three things of your own invention write a count and the weight of one piece, multiply each pair and then add everything up.
| A | B | |
|---|---|---|
| 1 | 1.5 | 6 |
| 2 | 2 | |
| 3 | 4 | |
| 4 | 0.5 |
| A | B | |
|---|---|---|
| 1 | Price | Quantity |
| 2 | 4200 | 5 |
| 3 | 7500 | 2 |
| 4 | 1800 | 10 |
| 5 | 54 000 |
“One formula”: groups build an order table with 5 products; first they calculate each row total separately and add them, then check the result with one SUMPRODUCT formula.