HomeApplicationOffice information

How to use the DAVERAGE function in Excel

Along with the SUM function, the function displays the time on the NOX system, the function calculates the number of NETWORKDAY working days, . in the basic functions in Excel, the AVERAGE function is a familiar function for very Many people often have to work with spreadsheets. However, with the fields in the list having the given conditions for calculating the average value, we will not be able to use the AVERAGE function.

In this case, you will need to use the DAVERAGE function. DAVERAGE function helps calculate the average value of the series of data with given conditions. In this article, we will show you how to use the DAVERAGE function in Excel.

How to use the DAVERAGE function in Excel

The DAVERAGE function has the following syntax:

DAVERAGE (database, field, criteral)

Inside:

  1. Database : cell range, list or database including header, is forced parameter.
  2. Field : specifies the column used in the function, the cell has no column header or column header name.You need to enter the column header name enclosed in quotation marks.It is also possible to use a number to represent the column position, for example the first column is 1, the second column is 2.
  3. Criteral : range of conditional cells, you can use any range in the table.But that range contains at least one column header and at least one cell containing the condition under that column heading.

We have the following example table:

You will conduct product averages for employees on condition of age 24.

How to use the DAVERAGE function in Excel Picture 1

Case 1: Use relative address

In cell C8, you enter the following formula: = DAVERAGE (A3: C7, C3, C9: C10)

How to use the DAVERAGE function in Excel Picture 2

Then press Enter and get the result as shown below.

How to use the DAVERAGE function in Excel Picture 3

Case 2: Use absolute address

In cell C8, we proceed to enter the formula: = DAVERAGE ($ A $ 3: $ C $ 7, C3, $ C $ 9: $ C $ 10)

How to use the DAVERAGE function in Excel Picture 4

Press Enter and get the result as shown below:

How to use the DAVERAGE function in Excel Picture 5

Above is how to use Excel's DAVERAGE function with two cases of relative address and absolute address. Depending on the situation you use to enter the data formula accordingly.

Refer to the following articles:

  1. 10 ways to recover corrupted Excel files
  1. You want to print text, data in Microsoft Excel. Not as simple as Word or PDF! Read the following article!
  1. Summary of expensive shortcuts in Microsoft Excel

I wish you all success!

4 ★ | 1 Vote
ExcelExcel functionAVERAGE functionExcel tricks

You should read it

May be interested

  • How to use Excel's VALUE functionHow to use Excel's VALUE function
    excel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
  • How to use the WRAPROWS function in ExcelHow to use the WRAPROWS function in Excel
    having trouble with handling large data sets in excel? then learn how to use the wraprows function to split them into more manageable rows.
  • How to use the IFS function in Excel 2016How to use the IFS function in Excel 2016
    the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.
  • How to use the NPER function in Excel to plan loans and savingsHow to use the NPER function in Excel to plan loans and savings
    do you want to effectively manage and control your personal finances? then we invite you to learn how to use excel's nper function.
  • How to use the function to delete spaces in ExcelHow to use the function to delete spaces in Excel
    deleting white space with functions in excel makes it easier for users to handle content, instead of traditional editing.
  • How to fix the SUM function doesn't add up in ExcelHow to fix the SUM function doesn't add up in Excel
    in the process of summing with sum in excel, you will encounter some errors such as not jumping the number, not adding the sum. so how to handle this problem?
  • How to use the SUBTOTAL function in ExcelHow to use the SUBTOTAL function in Excel
    the subtotal function in excel is used in many different cases, helping you to sum subtotals in a list or database, unlike the sum function in excel such as counting cells, calculating average, finding the largest / smallest value. or sum the filtered list values ​​in excel
  • Save time with these text formatting functions in Microsoft ExcelSave time with these text formatting functions in Microsoft Excel
    microsoft excel is a main application for anyone who has to work with numbers, from students to accountants. but its usefulness extends beyond a large database, it can do a lot of great things with text. the functions listed below will help you analyze, edit, convert, change text and save many hours of boring and repetitive tasks.
  • SUMPRODUCT function in Excel: Calculates the sum of corresponding valuesSUMPRODUCT function in Excel: Calculates the sum of corresponding values
    the sumproduct function is an extremely useful function when you have to deal with a lot of data numbers in microsoft excel. here are the things you need to know about the sumproduct function in excel.
  • How to use the SUMIF function in ExcelHow to use the SUMIF function in Excel
    the sumif function in excel is a function used to compute values ​​in a specified range. the sumif function can be used for summing cells based on the date, data and text that are connected to the specified area.

Office information