All of Excel's Database functions and some of the Statistical functions have a criteria argument that allows you to filter specific data for which the function performs it's calculation on. The criteria can be very simple or more complex. Here, we'll discuss some of the more advanced uses of the criteria argument.

#1)
Let's use the DAVERAGE function to illustrate:
#2)
Now let's talk about the field - the data we are interested in:
#3)
Now, let's specify the criteria and look at the results:
Note:
This is a simple use of the criteria argument. We'll look at more advanced criteria below.
#3)
Using a more advanced critera:

Summary

All of Excel's Database functions and some of the Statistical functions have a criteria argument that allows you to filter specific data for which the function performs it's calculation on. The criteria can be very simple or more complex.