Skip to main content
SheetTutor.
SheetTutorLearn Excel by playBack to task

Describe the numeric records selected by criteria

Your goal: Report mean and extremes for the actual selected numeric observations.

Full 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.

Exact text, signed observations and a zeroInclude the original database headers0 cells selected
Database A1:E13 · criteria H1:K3 · field H6. Criteria are stored text, including leading = signs.Scroll the worksheet vertically for later source rows and horizontally for later columns.
Click or drag source cells; selected cells change color Drag from selected cells to deselect.
#
1
2
3
4
5
6
7
8
9
10
11
12
13
Step 1 of 6

Include the original database headers

Select the source cells in the worksheet, then enter your prediction below.

Rules for this step

Select A1:E13, including the field names and all twelve source records. The database argument is the complete table, before criteria select records.

0 cells selected