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

Comments

Post a Comment

Popular posts from this blog

Excel DGET function - Notes and Example

Image
What does DGET do ? The DGET function is used to find a single value from a database (table) that matches the given condition (criteria). It returns a result only when one unique record satisfies the criteria. Syntax =DGET(database, field, criteria) Argument Explanation :- Database -  Select the complete table including column headings. Field- Select the column number or column heading from which the value is required. Criteria- Select the range that contains column heading with condition. Example Table :- Formula Example:-  Database › whole table Field › Sales Criteria Range › First Name                                 Neha Important Note - • The criteria must return only one matching record. • If no record or multiple records match, Excel returns an error. Watch on YouTube > DGET function  
Read more

Excel DSUM Function – Notes and Example

Image
What does DSUM do? The DSUM function is used to calculate the sum of values in a database (table) based on given criteria. It works only when data is arranged in a proper table with headings. Syntex :-  =DSUM(database, field, criteria) Arguments Database – Select the complete table including headers Field – Column name or column number to sum Criteria – Range containing conditions Example  Data Table :- Formula Example :-  Database › whole table Field › Qty Criteria range › Product                                 Laptop  Use of Dsum » →Sales reports →Brand-wise totals →Category-wise analysis →Simple database-style calculations Note :- DSUM works only when: Table has proper headers Criteria range also includes headers Watch on YouTube ⟩ DSUM Function  
Read more