Using the SUM function must be one of the first things people learn when they start using Excel. Quite often it is because they have used the AutoSum button but it creates the SUM function for you.
There is a SUMIF function that sums up a range of numbers based on criteria, for example, you may want to only total up items based on a particular product. You can see how to use the SUMIF function by clicking here. But what if you have more than one set of criteria to sum up on, lets say you have the year that a product was sold and you want to know how many items of certain product were sold in a particular year, then you need the SUMIFS function. With this function you can have 127 different criteria, that sounds like a lot but I’m sure someone needs it.
Here in the video tutorial below you can see how it works