How to Use MAXIFS in Google Sheets

MAXIFS is a function in Google Sheets that returns the maximum value that meets multiple criteria within a given range. It is useful when you want to find the highest value in a dataset that fulfills specific conditions.

Here's how to use the MAXIFS function in Google Sheets:

1. Open a Google Sheet and enter your data in a structured format.
2. In an empty cell, type the following formula:

=MAXIFS(max_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

• max_range: The range of cells where the maximum value will be found.
• criteria_range1: The range of cells where the first criterion will be applied.
• criterion1: The condition that must be met in the first criteria range.
• [criteria_range2, criterion2, ...]: Optional additional criteria ranges and conditions. You can add as many criteria as you need.

3. Replace the range and criteria placeholders with the appropriate cell references and conditions for your dataset.
4. Press Enter to apply the formula, and the result will be displayed in the selected cell.

Example

Let's say you have a dataset containing sales data for different product categories and regions, and you want to find the highest sales value in the "Electronics" category for the "North" region. Your data looks like this:

A             B             C
--------------------------------
1 | Category   | Region      | Sales
2 | Electronics | North      | 1200
3 | Electronics | South      | 1500
4 | Furniture  | North      | 800
5 | Electronics | North      | 900
6 | Furniture  | South      | 1100

Use the following MAXIFS formula to find the highest sales value for the "Electronics" category in the "North" region:

=MAXIFS(C2:C6, A2:A6, "Electronics", B2:B6, "North")

• max_range: C2:C6 (The range where the maximum value will be found)
• criteria_range1: A2:A6 (The range where the first criterion will be applied)
• criterion1: "Electronics" (The condition to be met in the first criteria range)
• criteria_range2: B2:B6 (The range where the second criterion will be applied)
• criterion2: "North" (The condition to be met in the second criteria range)

After applying the formula, the result will be 1200, which is the highest sales value for the "Electronics" category in the "North" region.