This video shows the power of the SUMIF, COUNTIF, and AVERAGEIF functions. These are great if we only want to analyze a specific segment of our data. Sure, we could filter it and use the total row to find out the answer, but then if someone changes our filter…well…then our answer is gone:( So these functions are great for analyzing data without worrying about how it is sorted or filtered.

This video uses SUMIFS, COUNTIFS and AVERAGEIFS allowing us to set up multiple criteria prior to doing our calculation. Now, we can verify multiple conditions before doing our calculation.