SheetsdrillMINIFS practice
MINIFS returns the smallest value among the cells that meet one or more conditions. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.
Syntax
MINIFS(range, criteria_range1, criterion1, ...)
What people get wrong
The cheapest item still in stock is MINIFS on the prices with stock greater than zero.
Google Sheets exercise that use MINIFS
- Cheapest item in stockLevel 2Pro
Practice MINIFS now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free