How to Use the Average Function in Google Sheets

This updated guide examines How to Use the Average Function in Google Sheets and organizes the essential facts, background, and practical takeaways in clear American English.

• How to count on multiple sheets of Google Sheets
• How to link data between spreadsheets in Google Sheets
• How to insert Google Sheets charts into Google Docs
• How to set up the right to edit spreadsheets on Google Sheets

How to use the AVERAGE function in Google Sheets

AVERAGE function has the syntax to use = AVERAGE (number1, [number2],.) .

Inside:

• number1: the first argument can be number, cell reference or range containing numbers to be averaged, required.
• number2: are numbers, cell references or ranges containing additional numbers that want to calculate an average of as many as 255 numbers, optional.

Note when using AVERAGE function:

• The cell reference argument or range containing logical values, text or empty cells is automatically omitted, with the value 0 still being counted.
• Logical values, indicating the number of text form entered directly into the list of arguments in the function will be counted.
• If the argument is text or the value cannot be converted to a numeric error, an error occurs.

We will average students' test scores according to the data sheet below.

Step 1:

In the first point calculation box, enter the formula = AVERAGE (C2: E2) and press Enter.

As a result we will see the average score of 3 subjects in the data table.

Step 2:

To calculate the average result for the remaining students, users just need to click on the first result box, then drag down the remaining cells.

Step 3:

The resulting average spreadsheet displays the decimal number with many values behind the period. To shorten the results , first black out the entire column and click on Format to edit the format.

Step 4:

Next click on Number , then select Number format .

The average score of 3 subjects has been neatened as shown below.

With the score of 0 behind you want to leave, just black out and then click on the 0 symbol with the left arrow to remove 0 . Each click is removed 1 after the decimal point.

So using the AVERAGE function in Google Sheets is very simple, there are not many combined data conditions. You only need to determine the area that needs to calculate the average of the total is okay.

I wish you all success!