Excel: Set up and calculate the matrix formula - how it works
With a matrix formula, multiple calculations can be done in Excel in one step. In this practical tip we will show you how to set up and calculate a matrix formula.
Create an Excel table for the matrix formula
For example, if you want to calculate the sales of several products in Excel that have different prices and were sold different times, it is worth using a matrix formula. In our example we want to calculate the turnover of a flower shop.
- First create a table in which you record the prices and sales figures for the different products. The "price" and "number" columns are the matrices. (In our example C3: C5 and D3: D5)
Set up the matrix formula in Excel
In addition to the table, you now have to set up the matrix formula.
- You can set up the matrix formula in any cell. Write the following formula:
- = SUM (C3: C5 * D3: D5)
- Definitely end the entry with the key combination [Ctrl] + [Shift] + [Enter], because this is the only way Excel recognizes the matrix formula.
If you have several matrix formulas in a table, we will show you how you can compare the individual cells in Excel.