How can I calculate the average value of a range of cells in Google Sheets?

How can I calculate the average value of a range of cells in Google Sheets?

By /

To calculate the average value of a range of cells in Google Sheets, first select the cells you want to include in the calculation. Then, click on the “Functions” button and select “Average” from the list of options. This will automatically calculate the average value of the selected cells and display it in the cell where the function was entered. Alternatively, you can manually type in the function “=AVERAGE(range)” where “range” is the range of cells you want to include in the calculation. This will also display the average value in the designated cell.

AVERAGE

The AVERAGE function returns the numerical average value in a dataset, ignoring text.

Examples

Make a copy

[wpcc-iframe height=”300″ width=”500″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdHhBaV9iUjAtLWctSklUMmZuRU1ldFE&output=html”]

AVERAGE for BigQuery

Sample Usage

Returns the numerical average value in a data column.

Sample Usage

AVERAGE(table_name!price)

Syntax

AVERAGE(column)

  • column: The data column to consider when calculating the average value.

Tip: Averaging multiple columns is not supported.

Learn more about numeric columns in BigQuery

Sample Usage

AVERAGE(A2:A100,B2:B100,4,26)

AVERAGE(1,2,3,4,5,C6:C20)

Syntax

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

  • value1 – The first value or range to consider when calculating the average value.

  • value2, ... – [ OPTIONAL ] – Additional values or ranges to consider when calculating the average value.

Notes

  • Although AVERAGE is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.

  • Any text encountered in the value arguments will be ignored. To have text values considered as 0 values, use AVERAGEA.

  • AVERAGE returns the mean of the combined value arguments; that is, the sum of the values in the value arguments divided by the number of such values. To calculate the median use MEDIAN.

See Also

TRIMMEAN: Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.

SMALL: Returns the nth smallest element from a data set, where n is user-defined.

RANK: Returns the rank of a specified value in a dataset.

QUARTILE: Returns a value nearest to a specified quartile of a dataset.

PERCENTRANK: Returns the percentage rank (percentile) of a specified value in a dataset.

PERCENTILE: Returns the value at a given percentile of a dataset.

MINA: Returns the minimum numeric value in a dataset.

MIN: Returns the minimum value in a numeric dataset.

MEDIAN: Returns the median value in a numeric dataset.

MAXA: Returns the maximum numeric value in a dataset.

LARGE: Returns the nth largest element from a data set, where n is user-defined.

HARMEAN: Calculates the harmonic mean of a dataset.

GEOMEAN: Calculates the geometric mean of a dataset.

AVERAGEA: Returns the numerical average value in a dataset.

Cite this article

stats writer (2024). How can I calculate the average value of a range of cells in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-calculate-the-average-value-of-a-range-of-cells-in-google-sheets/

stats writer. "How can I calculate the average value of a range of cells in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-calculate-the-average-value-of-a-range-of-cells-in-google-sheets/.

stats writer. "How can I calculate the average value of a range of cells in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-calculate-the-average-value-of-a-range-of-cells-in-google-sheets/.

stats writer (2024) 'How can I calculate the average value of a range of cells in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-calculate-the-average-value-of-a-range-of-cells-in-google-sheets/.

[1] stats writer, "How can I calculate the average value of a range of cells in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.

stats writer. How can I calculate the average value of a range of cells in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)

Related terms:

  1. How can I use Google Sheets to calculate the average of a range of cells, excluding any cells that are blank?
  2. How can I use the AVERAGE function in excel to calculate the average value of a range of cells?
  3. How can I use the AVERAGEIF function in Google Sheets to find the average value of a range of cells based on a certain criteria?
  4. How can I use the AVERAGEIFS function in Google Sheets to calculate the average of a range of cells based on multiple criteria?
  5. How can I calculate the average value of a range of cells in excel using the AVERAGEA function?
  6. What is the average of a range of cells in Excel, excluding any blank cells?
  7. How can I use the MIN function in Excel to find the smallest value in a range of cells, excluding any cells that contain a zero?
  8. How can I use the MINA function in Excel to find the minimum value in a range of cells, including any cells that contain text or logical values?
  9. How can I use the AVERAGEIF function in Excel to calculate the average of a range of cells based on specified criteria?
  10. How can I use the AVERAGEIFS function in Excel to calculate the average of a range of cells based on multiple criteria?
Slide Up
x
PDF
Scroll to Top