Formulas > =MAXIFS()
How to Use MAXIFS() in Google Sheets
Description
How To Actually Use MAXIFS() in Sheets
MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)
Try MAXIFS yourself
In the range B2:B10, find the maximum value where the corresponding values in A2:A10 are greater than 50. Your formula should return the correct maximum value.
Hints (2)
-
Remember to specify the range for the maximum values first.
-
Use the criteria to filter the values in the first range.
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 BetterSheets.co/formulas
Learn more about the MAXIFS() formula:
Generate a MAXIFS() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses MAXIFS(). 2 free AI generations, no signup. Members get unlimited use.
Generate a MAXIFS() formula