The SUMIF function calculates the sum of specific cells according to a criterion, like a product, country, seller's name, ...
In Excel, you can build 3D formulas by making a relationship through many worksheets. Let's see how to build a 3D formula.
SUM is the most used Excel function. There is nothing complex to use this function but there is also tricks behind this function
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.
A running total is a very useful mathematical operation which is very simply to build in Excel.
Learn how to use the basic Excel functions. With this exercise, you will see how easy it is to use Excel functions.
What are the 10 most useful Excel functions that you need to know? This article presents them with examples.