SheetFX
≡
<< Go back to all functions

MAXIFS

The MAXIFS function in Google Sheets is a powerful tool to return the maximum value in a range of cells, filtered by a set of criteria. Whether you're analyzing sales data, tracking inventory, or evaluating student performance, the MAXIFS function simplifies the task. Explore our comprehensive guide below to learn how to apply this function effectively.

Function Syntax and Parameters

Syntax: MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], ...)

Parameters:

  • range: The range of cells to evaluate.
  • criteria_range1: The range to test against the first criterion.
  • criterion1: The criterion or condition to use with the first range.
  • criteria_range2, criterion2, ...: [Optional] Additional ranges and criteria to apply.

Step-by-Step Tutorial

  1. Using MAXIFS with a single criterion:

    • Example: If A1:A5 has the values 5, 10, 3, 8, 7, and B1:B5 has the values Red, Blue, Blue, Red, Red, then =MAXIFS(A1:A5, B1:B5, "Red") will return 8.

  2. Using multiple criteria with MAXIFS:

    • Example: If A1:A5 has the values 5, 10, 3, 8, 7, B1:B5 has the values Red, Blue, Blue, Red, Red, and C1:C5 has the values Apple, Banana, Banana, Apple, Apple, then =MAXIFS(A1:A5, B1:B5, "Red", C1:C5, "Apple") will return 8.

Use Cases and Scenarios

  1. Inventory Management: Find the maximum quantity for a specific product.
  2. Sales Analysis: Identify the highest sales figure for a particular region and product.
  3. Student Performance: Determine the highest score achieved by a student in a specific subject.

Related Functions

  • MIN: Find the smallest value in a set.
  • MINIFS: Like MAXIFS, but returns the minimum value based on specific criteria.

Related Articles