How To Use CountIF, SumIF and AverageIF Functions (Video transcript)
In this lecture, we will see the Count IF family functions. Count IF, Sum IF and Average IF functions.
Let’s start with the Count IF functions, we have a list of the category with its price and revenue generated. We want to know how many items are available in each category. To calculate that we will use the Count IF functions.
Let’s inter that useful formula here. =Count IF (The range will be column A, the category itself and the criteria are the category name, so select Kitchen or G4) and enter. We can double click to work for the other Items. Now we have total items in each department.
What are we want to know about the total revenue of each item? In this case, we will use the Sum If function. So let’s enter that formula. =Sum IF (the range will be the department and the criteria will be the Item name and finally the sum range will be the revenue. close the brace and enter. Now we have the total revenue for each item in the departments.
last but not least we can see the Average function. our goal is to find the average price for each item category. So to do that enter the Average IF function here. =Average IF (the range will be the department and the criteria will be the Item name and the average range will be the price) close the brace and enter. we can drag for the others also.
So these are powerful tools and easy to use as well.