|
|
The basic calculations - Sum multi-dimensional
Page visited 19886 times
|
1. With Excel, it is possible to create multi-dimensional sum.
Indeed, it is just the way to calculate throught several sheets.
|
|
|
|
|
|
|
|
|
2. For instance, we have a spreadsheet for each month and a sheet for summarise the quarter.
|
|
|
|
|
|
|
|
3. So, we start to write to begin of the formula SUM
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
4. Then, we select the 3 spreadsheets together. To do that, you select the first sheet (January), then you press the 'Shift' key and you select the last sheet (March).
You should have the same result as the next image.
|
|
|
|
|
|
|
|
|
5. And to finish, you select the cell B3
|
|
|
|
|
|
|
|
|
6. Magic ! The result in the sheet 'Quarter' is the sum of January, February and March.
Of course, this is possible only if your all sheets have the same structure.
|
|
|
|
|
|
|
|
|
