
Let's use the DAVERAGE function to illustrate:



Now let's talk about the field - the data we are interested in:


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.
This is a simple use of the criteria argument. We'll look at more advanced criteria below.

Using a more advanced critera:




