FormuladrillMAXIFS practice
MAXIFS returns the largest value among the cells that meet one or more conditions. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.
Syntax
MAXIFS(range, criteria_range1, criterion1, ...)
What people get wrong
The best sale in one region is MAXIFS on the amounts with the region as the criterion.
Excel exercise that use MAXIFS
- Best sale in a regionLevel 2Pro
Practice MAXIFS now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free