How To Use DAVERAGE Function | Microsoft Excel

how to use daverage function

DAVERAGE function is used to get average from the database for the field you want by applying criteria or condition

Syntax of DAVERAGE Function


Arguments of DAVERAGE Function

database: The range of the data in the first row contains lables and columns under labels are records
field: use lable or number of a column which you want in the result
criteria: a range of the condition with label

Behaviour of DAVERAGE Function

How to use dtabase function in excel

Here we have taken an example of all months and its sell and quantity and its total amount 
Database: The database is started from the row A4 to D16. The first row is selected as labels and remaining data is known as records.
Field: For which label you want to apply a condition or criteria. here you can write a label name or its column number, For Example, you want to use condition for sell then you have to write "sell"(sell in a double quote) or just write 2(which is column number of sell) 
Criteria: criteria is a condition: For Example, You want to search in sell in which month selling is greater than 7 or Quantity is less than 1500 than you can apply this condition by writing it in the criteria Section below the specific label.

Usage of DAVERAGE Function

To calculate an average from the database where criteria applied

Return of DAVERAGE Function

Average of the conditionally applied record 

How would you like this content to write us in the comment box!
If you face any difficulty in the content feel free to ask!
Thank You.

No comments:

Post a Comment