Tag Archive: SUM

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. What is the problem? 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 "Year". You …

Continue reading »

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 …

Continue reading »

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

Dynamic SUM in Excel

Create a SUM is something very easy with Excel. But when you want to add only some specific cells and not all of them, the formula is not so easy but it's possible. Let's see how to create a dynamic SUM.   Insert your data in a Table But before to explain how to create …

Continue reading »

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