Formulas > =MAXIFS()

How To Use MAXIFS() Function in Google Sheets


Returns the maximum value in a range of cells, filtered by a set of criteria.

Common Questions about the MAXIFS Formula:
• What is the syntax of the MAXIFS formula?
• What are the different arguments of the MAXIFS formula?
• How does the MAXIFS formula work?
• Can the MAXIFS formula be used across multiple ranges?

How Can the MAXIFS Formula be Used Appropriately:
The MAXIFS formula can be used to find the maximum value within a range of cells based on one or more criteria. It is designed to work across multiple ranges, allowing for different criteria to be specified for each.

How Can The MAXIFS Formula Be Commonly Mistyped:
The MAXIFS formula is commonly mistyped as MAXIF. Other misspellings are MAXFS, MAXISF, MXIFS, MXAIFS.

What Are Some Common Ways The MAXIFS Formula Is Used Inappropriately:
The MAXIFS formula is not designed to compare cells or values with each other, so it should not be used to do so.

What Are Some Common Pitfalls when Using the MAXIFS Formula:
• The MAXIFS formula requires that the range and criteria be identical in size and parameters. Otherwise, it will return an invalid result.
• The MAXIFS formula may return incorrect results when used to compare two sets of range data with different lengths.
• The MAXIFS formula does not recognize Boolean data types, so data of this type must be converted to numerical values.
• The MAXIFS formula is not designed to work with any array operations.

What Are Common Mistakes When Using the MAXIFS Formula:
• Not using the correct syntax when writing out the formula.
• Not specifying enough criteria or ranges.
• Forgetting to format results as number data types before attempting to use the MAXIFS formula.
• Incorrectly assuming that the MAXIFS formula can be used to compare cells or values with each other.

What Are Common Misconceptions People Might Have With The MAXIFS Formula:
• That the MAXIFS formula can be used with any type of data.
• That the MAXIFS formula can be used to compare two sets of range data with different lengths.
• That all criteria must be specified for the MAXIFS formula to work.
• That the MAXIFS is a replacement for the MAX function.

How To Actually Use MAXIFS() in Sheets

MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the MAXIFS() formula:

Google Sheets Tutorial for Sports Science: Unlock the Power of MAXIFS

This is a video designed for sports scientists, sport and strength coaches, and other practitioners working in sport on how to get the most out of Google Sheets for sports science and performance. We learn how to use the function MAXIFS in a variety of real-world scenarios in the sports science world. You've probably never used MAXIFS 3 times in the same formula before, but after this video, you will see when and why you should!

Generate a MAXIFS() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.