SheetFX
≡
<< Go back to all functions

AVERAGE

The AVERAGE function in Google Sheets calculates the numerical average value in a dataset, ignoring text. This function is useful for various calculations such as finding the average score, average monthly sales, or average expenses. Learn how to use the AVERAGE function effectively with our comprehensive guide.

Function Syntax and Parameters

Syntax: AVERAGE(value1, [value2, ...])

Parameters:

  • value1: The first value or range to include in the average calculation.
  • value2, ...: [Optional] Additional values or ranges to include.

Step-by-Step Tutorial

  1. Using AVERAGE with individual numbers:

    • Example: =AVERAGE(3, 10, 5)
    • Result: 6

  2. Using AVERAGE with a range of cells:

    • Example: If A1:A5 has the values 5, 10, 3, 8, 7, then =AVERAGE(A1:A5) will return 6.6.

Use Cases and Scenarios

  1. Grades Calculation: Calculate the average score of a student across different subjects.
  2. Sales Analysis: Determine the average sales per month or per product category.
  3. Expense Management: Find the average monthly expenses for budget planning.

Related Functions

  • SUM: Add up values in a range.
  • COUNT: Count the number of cells containing numbers.

Related Articles