Count records that meet several conditions
In F6, count rows matching the team in F2, status in F3 and maximum age in F4.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
A LITTLE PRACTICE
Runs in your browserMake the formula your own.
View task requirements
In F6, count rows matching the team in F2, status in F3 and maximum age in F4.
No account. No upload. Just try it.