# How to Calculate Average If Not Blank in Google Sheets

To calculate the average of a range of cells in Google Sheets, excluding the blank cells, you can use the AVERAGEIF function. The AVERAGEIF function calculates the average of numbers in a range that meet a specified criterion. In this case, the criterion is "not blank."

Here's how to use the AVERAGEIF function to calculate the average if not blank:

- Open your Google Sheets document.
- Click on the cell where you want the result to be displayed.
- Type the following formula:

`=AVERAGEIF(range, "<>", "")`

- Replace
`range`

with the actual range of cells you want to calculate the average for. - The "<>" symbol is used to represent "not equal to."
- The empty double quotes ("") represent a blank cell.

- Press Enter to see the result.

## Example

Let's say you have a list of numbers in cells A1 to A6, and you want to calculate the average, excluding the blank cells.

- Click on the cell where you want the result to be displayed, for example, cell B1.
- Type the following formula:

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

- Press Enter to see the result. The formula will calculate the average of the numbers in cells A1 to A6, excluding the blank cells.

Did you find this useful?