Functions
DAVERAGE
Average of field values for rows matching criteria
Try it
When to use it
When should I use DAVERAGE?
Use DAVERAGE to compute the average of a field across only the rows in a database table that match one or more criteria — useful when you need a conditional average over a structured table rather than a flat range.
Used in
Syntax
DAVERAGE(database, field, criteria)Examples
=DAVERAGE({"Name","Score";"Alice",80;"Bob",90;"Carol",70},"Score",{"Score";">75"}) // => 85