Advanced Formulas — SUMIFS, COUNTIFS, and AVERAGEIFS

In this lesson, we will learn SUMIFS, COUNTIFS, and AVERAGEIFS in Excel. We will understand how to sum, count, and calculate averages based on one or multiple conditions through practical data analysis examples. ## Lesson objective In this lesson, we will cover advanced formulas in Excel: , , and . In the previous lesson, we learned Data Transformation with Power Query. We understood how to import data, change data types, clean text, split columns, merge, append, and refresh data with Power Query. Now we go deeper into condition-based calculations in Excel. In previous lessons, we covered , , , , and logical functions.