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.
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.
SUMIF Function in Excel The SUMIF function calculates the sum of specific cells according to a criterion, like a product, country, seller's name, ...
Running Total in Excel A running total is a very useful mathematical operation which is very simply to build in Excel.
Function SUM SUM is the most used Excel function. There is nothing complex to use this function but there is also tricks behind this function