SheetFX
≡
<< Go back to all functions

AVERAGEIFS

The AVERAGEIFS function in Google Sheets returns the average of a range depending on multiple criteria. This function allows you to calculate the average value based on specific conditions. Whether you're analyzing sales data, student grades, or any other dataset, the AVERAGEIFS function simplifies the task.

Function Syntax and Parameters

Syntax: AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Parameters:

  • average_range: The range of cells to be averaged.
  • criteria_range1: The first range to apply the criteria on.
  • criterion1: The condition to be met in the first range.
  • [criteria_range2, criterion2, ...]: [Optional] Additional ranges and criteria to consider.

Step-by-Step Tutorial

  1. Using AVERAGEIFS with a single criterion:

    • Example: =AVERAGEIFS(B2:B10, A2:A10, ">5")
    • Result: Calculates the average of cells in range B2:B10 that meet the criterion ">5" in range A2:A10.

  2. Using AVERAGEIFS with multiple criteria:

    • Example: =AVERAGEIFS(B2:B10, A2:A10, ">5", C2:C10, ">0")
    • Result: Calculates the average of cells in range B2:B10 that meet the criteria ">5" in range A2:A10 and ">0" in range C2:C10.

Use Cases and Scenarios

  1. Sales Analysis: Calculate the average sales for a specific product category and time period.
  2. Academic Grading: Find the average grade for students who achieved a specific score in multiple exams.
  3. Budget Analysis: Determine the average expense for a particular category and month.

Related Functions

  • AVERAGE: Find the average value in a set of numbers.
  • AVERAGEIF: Calculate the average of a range based on a single criterion.
  • AVERAGEA: Like AVERAGE, but it evaluates text and other data types as well.

Related Articles