# Articles sur le thème : SUM

## 3D Function

Excel performs calculations in a spreadsheet but it is also possible to perform calculations across multiple worksheets, this is called 3-dimensional (3D) functions. A 3D formula simplifies your writing Say you have a workbook that contains one sheet per month. You want to create a worksheet that will synthesize all these month in a worksheet …

Permanent link to this article: https://www.excel-exercise.com/3d/

## Function SUM

This is the most commonly formula used and also the simplest to use. We will see in this page, different methods to perform a SUM in Excel. Presentation of the SUM function To perform a SUM function in Excel You simply start with the = sign in your cell Then, you enter the word SUM Then …

Permanent link to this article: https://www.excel-exercise.com/function-sum/

## Dynamic SUM in Excel

There is 2 methods to create a dynamic SUM in Excel.
The first one uses the technique with a Table, the second one uses the function INDEX.

Permanent link to this article: https://www.excel-exercise.com/dynamic-sum-in-excel/