To average only non-blank cells in Excel, you need to use the AVERAGEIF function. And in the criteria, you need to use does not equal operator to refer to only non-blank cells. In this tutorial, we will look at this formula in depth.

## Average Only Cells which are Not Blank

You can use the following steps:

- First, in cell C1, enter the AVERAGEIF function.
- After that, in the first argument (range) refer to the range A1:A9.
- Now, in the second argument, enter does not equal the operator using double quotation marks.
- In the end, enter the closing parentheses and hit enter to get the result.

`=AVERAGEIF(A1:A9,"<>")`

When you use it, AVERAGEIF only considers cells that are non-blank and averages only those cells. You can see when I select the cells where we have value it shows the same average on the status bar.

## A Problem You Might Face

There’s might be a situation where you have a blank cell in the range and that blank cell have an invisible space. In this case, your formula won’t consider that cell as a blank and calculate the average including it as well.

Well, you can use the below formula where we have used AVERAGEIF to specify two criteria, one is to include non-blank cells and the other is to ignore cells with a space.

`=AVERAGEIFS(A1:A9,A1:A9,"<>",A1:A9,"<>"&" ")`

## Download Sample File

## More Formulas

- Calculate Compound Interest in Excel
- Calculate Cube Root in Excel
- Calculate Percentage Variance (Difference)
- Calculate Simple Interest in Excel
- Calculate SQUARE ROOT in Excel
- Calculate the Weighted Average in Excel
- Does Not Equal Operator in Excel
- Round a Number to Nearest 1000, 100, and 10
- Round to Nearest .5, 5. 50 (Down-Up) in Excel
- Square a Number in Excel