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

Summarize records selected by a criteria table

Your goal: Read AND/OR criteria from cells and keep the numeric population visible.

Full task requirements

Enter separate formulas in N5 and O5. Use the database A1:E13, field header H6 and complete criteria range H1:K3. N5 is the sum of numeric values in the selected field; O5 is their numeric count. Conditions across one criteria row combine with AND; the two rows combine with OR. Repeated Units headers apply both numeric bounds to the same record. Keep each selected record once even when it matches both rows. Keep numeric zeroes and signed amounts; referenced text, numeric-looking text, booleans and blanks do not contribute to either statistic.

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