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:

1. Open your Google Sheets document.
2. Click on the cell where you want the result to be displayed.
3. 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.

4. 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.

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

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

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