Excel DAVERAGE Function
The Excel DAEVARAGE function returns the average of values in a field of records in a list or database that match the specific criteria.
The DAVERAGE function will return the average value in a given field based on some specific criteria.
As the below screenshot shown, how to average the quantity of TV only in store C? Here I will show you how to achieve it with DAVERAGE function in Excel.
1. Select a blank cell to output the result, copy and paste the below formula into it and press the Enter key to return the average.
1) In the formula, B2:F13 is the database you will operate; “quantity” means that you will calculate the average from this quantity column; and H3:I4 is the conditions range including headers.
2) You can replace “quantity” with certain index number (here use number 4 to represent the fourth column in the database): =DAVERAGE(B2:F13,4,H3:I4).
3) For averaging the quantity of TV in all stores, please apply the below formula.