COUNTIFS and SUMIFS

Previously we used COUNTIF() and SUMIF() to aggregate data into groups by Sales Month. We built an interesting trend analysis that lead to more questions.

COUNTIFS() and SUMIFS() are even more powerful than the previous functions we learned because of their ability to validate multiple logical arguments (hence the S) within the same function. We can use these functions to further segment our sales data and perhaps find some answers.

Continue working on the Sales Trends worksheet.

If you've lost progress, open up 2_3_countif_sumif.xlsx from the Workbooks folder.