Describe the numeric records selected by criteria
Enter separate formulas in N5, O5 and P5 using A1:E13, field header H6 and criteria H1:K3. Return the numeric arithmetic mean, minimum and maximum, in that order. Include each matching source record once, including numeric zeroes and signed observations. Text, numeric-looking text, booleans and blanks in the chosen field are not numeric observations. If no numeric observations remain, return genuine #DIV/0! for the mean and numeric zero for both extremes. Do not replace the missing mean with a zero or a label.
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.
Make the formula your own.
View task requirements
Enter separate formulas in N5, O5 and P5 using A1:E13, field header H6 and criteria H1:K3. Return the numeric arithmetic mean, minimum and maximum, in that order. Include each matching source record once, including numeric zeroes and signed observations. Text, numeric-looking text, booleans and blanks in the chosen field are not numeric observations. If no numeric observations remain, return genuine #DIV/0! for the mean and numeric zero for both extremes. Do not replace the missing mean with a zero or a label.
No account. No upload. Just try it.