DAVERAGE in Google Sheets: Average Repair Times for Selected Jobs

A repair supervisor needs the average time per selected job. Each row represents one completed job, so each selected job has equal weight. The criteria cells stay visible beside the report so another person can inspect which records were intended to contribute.

=DAVERAGE(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 "Minutes", 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 =DAVERAGE(A1:D7,"Minutes",H1:H2) in F2. Expected result: 60.

Matched worksheet rows: 2, 3, 5, 7. Their selected Minutes entries are 30, 60, 50, 100. Check the explicit field index by replacing the formula with =DAVERAGE(A1:D7,4,H1:H2); the expected result remains 60.

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

Enter =DAVERAGE(A1:D7,"Minutes",H1:I2) in F2. Expected result: 40.

Matched worksheet rows: 2, 5. Their selected Minutes entries are 30, 50. 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 =DAVERAGE(A1:D7,"Minutes",H1:I3) in F2. Expected result: 66.6666666667 (66⅔, displayed with rounding).

Matched worksheet rows: 2, 5, 6. Their selected Minutes entries are 30, 50, 120. 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:

Enter =DAVERAGE(A1:D7,"Minutes",H1:I2) in F2. Expected result: 75.

Matched worksheet rows: 3, 4, 5, 7. Their selected Minutes entries are 60, 90, 50, 100. The bounded review excludes the 30-minute quick fix and the 120-minute outlier. Its four job durations sum to 300 minutes, so the mean is 75. This is a deliberately selected cohort, not the overall workshop average. Do not average workshop averages when the workshops have different job counts; aggregate the individual jobs for the intended population. Repeating a field header lets its lower and upper bounds apply together on the same row.

A low average can hide a slow individual job. Review the matched records before using this summary for staffing. The function is an unweighted mean, so a row representing ten jobs would distort a job-level interpretation.

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 "Minutes" 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. For production reports, test the exact data types and selection boundaries used in your own sheet.

• Google DAVERAGE 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.