Statistical Function - SUMIFS

If you want to calculate the total numerical values of a data set based on more than one category, then the SUMIFS function is the one for you!

The video shows the SUMIFS function in use. The final written calculation is below: ​ =SUMIFS($B:$B,$A:$A,$E5,$C:$C,F$4) ​ In this formula, $B:$B is our sum range, which contains the numerical values we want to add up. ​ $A:$A is the column that contains the data that might meet our first criteria requirement. ​ $E5 is where we find the word January in our second table. This is our first criteria requirement. ​ ​$C:$C is the column that contains the second criteria we are looking for. In our case, we are looking for the word paid, which can be found in cell F$4. ​ By using cell addressing correctly, we can write our SUMIFS calculation once and use the fill handle to complete the entire table.