SheetFX
≡
<< Go back to all functions

AVERAGEA

The AVERAGEA function in Google Sheets returns the numerical average value in a dataset. It is a useful tool for calculating the average of a set of numbers, including both numerical and non-numerical values.

Function Syntax and Parameters

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

Parameters:

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

Step-by-Step Tutorial

  1. Using AVERAGEA with individual values:

    • Example: =AVERAGEA(2, 4, "6", 8)
    • Result: 5

  2. Using AVERAGEA with a range of cells:

    • Example: If A1:A5 has the values 2, 4, "6", 8, "10", then =AVERAGEA(A1:A5) will return 6.

Use Cases and Scenarios

  1. Data Analysis: Calculate the average of a dataset that includes both numbers and text values.
  2. Survey Responses: Find the average rating of a set of responses, even if they include non-numeric values such as "N/A".
  3. Sales Data: Determine the average revenue generated by different products, including those with missing or incomplete data.

Related Functions

  • AVERAGE: Find the average of a set of numbers, ignoring non-numeric values.
  • AVERAGEIF: Calculate the average of a range based on specified criteria.
  • AVERAGEIFS: Calculate the average of a range based on multiple criteria.

Related Articles