Another of Excel's database functions is DAVERAGE.
Like the other functions in this group, DAVERAGE lets you specify one or more criteria which act as data filters .
Only those records that match the set criteria are included in DAVERAGE's calculations.
Once the data has been filtered, DAVERAGE will return the average value for a field of data chosen by you.
To find out all the details, read this tutorial on the Excel DAVERAGE function.