DCOUNT in Google Sheets: Count Numeric Inspection Readings

A quality team tracks samples before all readings are available. The Reading column deliberately mixes numbers with status text. A sample can match the filter without contributing a numeric reading. The criteria cells stay visible beside the report so another person can inspect which records were intended to contribute.

=DCOUNT(database, field, criteria)

• database: the complete rectangular range, including its field headers.
• field: the header of the column to aggregate, or its one-based position inside that range.
• criteria: a separate range with field headers and one or more rows of tests.

All examples explicitly supply all three arguments. Google’s database specification establishes the header grid: conditions on one row combine with AND; alternative rows combine with OR. Despite the phrase “SQL-like” in some help descriptions, pass a criteria range rather than a SQL statement.

Use a blank sheet. Enter the following original practice data in A1:D7, Copy only the four field columns; the leftmost Row column is a worksheet-row annotation, not data to enter. The numbered row 1 supplies A1:D1. The table heading above it repeats the field names only for readability; do not enter that display heading as an additional row. Enter numbers as numbers, without units appended. Keep the criteria and result outside this database range.

Use F2 for the result. The field argument will be "Reading", which selects column D. The equivalent index is 4, measured from A within A1:D7. Criteria may test other columns without changing which field supplies the result.

Clear H1:J4 before each setup so old criteria do not remain. Enter this grid, beginning at H1:

Enter =DCOUNT(A1:D7,"Reading",H1:H2) in F2. Expected result: 3.

Matched worksheet rows: 2, 3, 5, 7. Their selected Reading entries are 12, Pending, 0, 15. Check the explicit field index by replacing the formula with =DCOUNT(A1:D7,4,H1:H2); the expected result remains 3.

Clear H1:J4 before each setup so old criteria do not remain. Enter this grid, beginning at H1:

Enter =DCOUNT(A1:D7,"Reading",H1:I2) in F2. Expected result: 2.

Matched worksheet rows: 2, 3, 7. Their selected Reading entries are 12, Pending, 15. Both tests are on the same criteria row, so a record must pass both. Moving a test to another row would change the selection logic.

Clear H1:J4 before each setup so old criteria do not remain. Enter this grid, beginning at H1:

Enter =DCOUNT(A1:D7,"Reading",H1:I3) in F2. Expected result: 2.

Matched worksheet rows: 2, 3, 6, 7. Their selected Reading entries are 12, Pending, Review, 15. Each criteria row is a complete alternative. A record qualifies when it passes all tests in either row; it need not pass both alternatives.

Clear H1:J4 before each setup so old criteria do not remain. Enter this grid, beginning at H1:

The 10-through-15 band includes readings 12 and 15. For this numeric-band exercise, replace the status text in D3 and D6 with numeric sentinel values -1 first; those placeholders fall outside the band. This keeps the comparison demonstration entirely numeric rather than assuming how Sheets compares text to a number. Restore Pending and Review before repeating the earlier examples.

Enter =DCOUNT(A1:D7,"Reading",H1:I2) in F2. Expected result: 2.

Matched worksheet rows: 2, 7. Their selected Reading entries are 12, 15. Repeating a field header lets its lower and upper bounds apply together on the same row.

Zero is numeric: the 0 reading in row 5 contributes to the basic count. Pending and Review are intentionally plain text, not missing readings disguised as zeros. DCOUNT measures numeric entries, not all selected records.

If the result is unexpected, first list the records selected by each criteria row. Then check the aggregation separately. This distinguishes an incorrect filter from incorrect arithmetic.

• Keep A1:D7 inclusive of the header. Starting at A2 turns the first record into the apparent labels.
• Copy criteria headers from row 1 rather than inventing display labels. Check that "Reading" names the intended result field.
• Enter comparison criteria such as >=7 as cell contents, not as a SQL fragment or an extra formula argument.
• Keep the database range large enough for new records, but do not silently include unrelated totals below the register.
• If a formula fails to parse, check quotation marks, the leading equals sign, and the argument separator expected by your sheet. The examples use English function names and comma-separated arguments.
• If the filter matches no rows, inspect the filter before interpreting any output. This guide does not prescribe an error code or default for empty selections.

This guide targets Google Sheets as described in the saved official documentation reviewed October 19, 2026. The reviewed sources do not provide a first-supported version or a desktop-style release matrix. No mobile, offline, exported Excel, or other spreadsheet-engine behavior was tested. Recheck the worked records after importing or exporting a workbook.

The examples deliberately avoid wildcard rules, date-text parsing, formulas returning empty text, and errors in the selected field. Those edge cases are not established by the sources reviewed here. Do not borrow another product’s behavior for them. DCOUNT is always given an explicit field here; omitted-field behavior is not claimed.

• Google DCOUNT reference: function purpose and three-argument signature, reviewed from the saved first-party snapshot.
• Google database functions: field selection, criteria headers, AND/OR logic, repeated headers and unrestricted empty criteria cells.

All datasets, record selections and applications above are original instructional examples.