# Excel AVERAGEIF Function for Values Greater Than 0

Get FREE Advanced Excel Exercises with Solutions!

This tutorial will demonstrate how to use the AVERAGEIF function greater than 0 in excel. The AVERAGEIF function returns the average of the cells of an array that satisfy one or more given criteria. The criteria can be of the same array or a different array. In every company, educational institution, or anywhere this function is very important as it gives the proper average results to compare for a certain condition. In our case, we will try to find out the average greater than 0 using the AVERAGEIF function.

## Step-by-Step Procedures to Use AVERAGEIF Function for Values Greater Than 0 in Excel

Now, we will try to find out the average greater than 0 using the AVERAGEIF function in 3 steps. If you follow the steps correctly, you should learn how to show the print area in Excel on your own. The steps are:

### Step 1: Arranging a Dataset

Our goal is to arrange a dataset for ease of our understanding. In this case, we have the Product in column B, the Quantity in column C, and the Average Greater Than 0  in column D. We will gonna use this dataset to describe the whole process. The whole dataset image is below. ### Step 2: Inserting Proper Formula

Now, we want to get the average of only the quantities that are above zero in number. To do that we will gonna use the AVERAGEIF function. Insert the following formula in the D5 cell.

`=AVERAGE(IF(C5:C11<>0, C5:C11))` ### Step 3: Showing Final Result

Lastly, after using the formula, press the Enter button to get the desired result. You can easily change the formula according to your need. ## How to Use AVERAGEIF Function Between Two Values in Excel

We want to use the AVERAGEIF function to find the desired result between two values in excel. It is very important and useful for determining the final result while two-valued conditions are available. We can fulfill our goal by following the steps.

Steps:

• At first, arrange a dataset like the following image. • Second, in the E5 cell insert the following formula.
`=AVERAGEIFS(D5:D11,C5:C11,">=75",C5:C11,"<=85")` • Last, press the Enter button to get the desired result. ## How to Use AVERAGEIF Function for Cell Containing Text in Excel

Next, we want to use the AVERAGEIF function to find the desired result while the cell contains the text. In day-to-day life, it is the most used application for this function. Every store or company needs to find out the average of their products that contain text. So, it is very important to learn this process. We can do that by following the below steps.

Steps:

• To begin with, arrange a dataset like the following image. • In addition, in the D5 cell insert the following formula.
`=AVERAGEIF(B5:B11,"*Desktop*",C5:C11)` • Finally, press the Enter button to get the desired result. ## How to Use AVERAGEIF Function Between Two Dates in Excel

Moreover, we want to use the AVERAGEIF function to find the desired result between two dates in excel. When we are dealing with any project or trying to deliver a certain product to customers or achieve a certain goal, we always need to compare certain values between date ranges. So, we need to learn this process by following the below steps.

Steps:

• Firstly, arrange a dataset like the following image. • Secondly, in the E5 cell insert the following formula.
`=AVERAGEIF(C5:C11,">1/10/2022",D5:D11)` • Lastly, press the Enter button to get the desired result. ## Things to Remember

• In the case of using the formulas the most important thing is to select the desired cells properly. If you don’t select the cells properly then it can get you a confusing result.
• When you are dealing with this function with texts make sure that you have spelled the text exactly like the dataset. If you don’t spell it exactly, excel won’t able to find any result.
• You should download the excel file and use it for better understanding.

## Related Articles Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  