SUM

3D Formula in Excel

In Excel, you can build 3D formulas by making a relationship through many worksheets. Let's see how to build a 3D formula.

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.

The SUMIF function calculates the sum of specific cells according to a criterion, like a product, country, seller's name, ...

A running total is a very useful mathematical operation which is very simply to build in Excel.

SUM is the most used Excel function. There is nothing complex to use this function but there is also tricks behind this function