Excel DAVERAGE Function – Calculate Average Using Criteria
🔹 What is DAVERAGE Function? DAVERAGE function is used to calculate the average value from a database table based on given criteria. It works on database-style data. 🔹 Syntax =DAVERAGE(database, field, criteria) Database:- Complete data range including column headings. Field:- The column for which average is required (can be column name in quotes or column number). Criteria :- A separate criteria range with heading and condition. 🔹 Example Data Table Use of formula:- 🔹 Result Explanation DAVERAGE calculates the average of the selected column only for records that match the criteria. Rows that do not satisfy the condition are ignored. 🔹 Where DAVERAGE is Used Average sales based on brand Average marks of students Average salary by department Report-based data analysis 🔹 Important Points Headings are mandatory Criteria range must include heading Only numeric values are averaged Works best with structured data