### How To Use SUM And AVERAGE Function in Excel (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 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 is the category name, so select Kitchen or G4) and enter. We can double click to work for the others Items. Now we have the total items in each department.

What is we want to know the total revenue of each Items? 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.