The three most commonly used formulas in Excel that perform basic mathematical calculations are COUNT, SUM, and AVERAGE. Whether you’re managing a financial budget in Excel or simply keeping track of your next vacation, you’ve probably used one of these functions at some point.
How to use SUMIFS, COUNTIFS, and AVERAGEIFS in Excel (multiple criteria)
In this article, we'll discuss the basics of these three functions and their relevant and useful counterparts: COUNTIFS, SUMIFS, and AVERAGEIFS.
Let’s say we’re starting a new online business selling mobile phones and we have a sheet with the sales we made in the first two months. Download an example of an Excel spreadsheet here.
To know how many mobile phones we have sold, we can quickly use the COUNT formula as shown below:
