Table of Contents
The AVERAGEIFS function in Google Sheets allows users to calculate the average of a range of cells based on multiple criteria. This function can be used to specify certain conditions or criteria that must be met in order for the cells to be included in the average calculation. By using this function, users can easily filter and analyze data based on specific criteria, making it a valuable tool for data analysis and decision making. With the AVERAGEIFS function, users can efficiently calculate averages for large datasets and gain a better understanding of their data. This function is particularly useful for businesses, researchers, and individuals who need to analyze and interpret data in a more targeted and precise manner.
AVERAGEIFS
Sample Usage
Returns the average of a data column depending on multiple criteria.
Sample Usage
AVERAGEIFS(table_name!price, table_name!fruits, “Apple”, table_name!inventory, “<30”)
Syntax
AVERAGEIFS(average_column, criteria_column1, criterion1, criteria_column2, criterion 2)
average_column– The data column to average.criteria_column1– The data column to check against `criterion1`.criterion1– The pattern or test to apply to `criteria_column1`.criteria_column2– Additional data column to check.criterion 2– Additional criteria to check.
Sample Usage
AVERAGEIFS(A1:A10, B1:B10, ">20")
AVERAGEIFS(A1:A10, B1:B10, ">20", C1:C10, "<30")
AVERAGEIFS(C1:C100, E1:E100, "Yes")
Syntax
AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
average_range– The range to average.criteria_range1– The range to check againstcriterion1.criterion1– The pattern or test to apply tocriteria_range1.criteria_range2, criterion2, ...– [ OPTIONAL ] – Additional ranges and criteria to check.
See Also
AVERAGE: The AVERAGE function returns the numerical average value in a dataset, ignoring text.
AVERAGEA: Returns the numerical average value in a dataset.
AVERAGEIF: Returns the average of a range depending on criteria.
SUMIFS: Returns the sum of a range depending on multiple criteria.
COUNTIFS: Returns the count of a range depending on multiple criteria.
IF: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
MEDIAN: Returns the median value in a numeric dataset.
Cite this article
stats writer (2024). How can I use the AVERAGEIFS function in Google Sheets to calculate the average of a range of cells based on multiple criteria?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-averageifs-function-in-google-sheets-to-calculate-the-average-of-a-range-of-cells-based-on-multiple-criteria/
stats writer. "How can I use the AVERAGEIFS function in Google Sheets to calculate the average of a range of cells based on multiple criteria?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-averageifs-function-in-google-sheets-to-calculate-the-average-of-a-range-of-cells-based-on-multiple-criteria/.
stats writer. "How can I use the AVERAGEIFS function in Google Sheets to calculate the average of a range of cells based on multiple criteria?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-averageifs-function-in-google-sheets-to-calculate-the-average-of-a-range-of-cells-based-on-multiple-criteria/.
stats writer (2024) 'How can I use the AVERAGEIFS function in Google Sheets to calculate the average of a range of cells based on multiple criteria?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-averageifs-function-in-google-sheets-to-calculate-the-average-of-a-range-of-cells-based-on-multiple-criteria/.
[1] stats writer, "How can I use the AVERAGEIFS function in Google Sheets to calculate the average of a range of cells based on multiple criteria?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the AVERAGEIFS function in Google Sheets to calculate the average of a range of cells based on multiple criteria?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.