In this Article

*This tutorial will demonstrate how to calculate the average of a set of numbers while ignoring zero values in Excel and Google Sheets.*

## The AVERAGE Functions

The AVERAGE Function calculates the average of a set of numbers, including zeros. To calculate the average, ignoring zeros, you can use the AVERAGEIF Function.

## Ignore Zero Values With AVERAGEIF Function

This example calculates the **Average Score** of 5 teams while ignoring **Scores **with a value of 0:

1 |
=AVERAGEIF(C3:C7,"<>0") |

## Ignore Text and Blank Values with AVERAGE Function

The AVERAGE and AVERAGEIF Functions ignore text and blank values.

This example uses the AVERAGE Function to calculate the **Average Score** from a list while ignoring text and blank values:

1 |
=AVERAGE(C3:C7) |

## Treat Text Values as Zero With AVERAGEA Function

In order to treat text values as zero in the calculation of the average of a list of values, the AVERAGEA Function can be used:

1 |
=AVERAGEA(C3:C7) |

As with the AVERAGE and AVERAGEIF Functions, blank cells are ignored by the AVERAGEA Function

## Ignore Zero Values in Google Sheets

These formulas work in exactly the same way in Google Sheets as in Excel.