How do I use DAVERAGE with multiple criteria?

To use the DAVERAGE function in Excel with multiple criteria, follow these steps:

1. Create a Criteria Table:

   • Set up a separate table or range that outlines your criteria. This table should have the same column headers as your main data table.

   • Enter the criteria you want to filter by in this criteria table. For example, if you’re calculating the average sales based on region and year, your criteria table might look like this:

     Table

     Region	Year
     West	2020
     East	2021

2. Use the DAVERAGE Formula:

   • In your main data table, assume your sales data is in column B, and the criteria table is in cells B3:F4.

   • To calculate the average sales based on the specified criteria, use the following formula:

     =DAVERAGE(B7:F19, "Sales", B3:F4)
     

   • Explanation:

     • The first argument is the database (your main data table), which includes the column headers (B7:F19).
     • The second argument specifies the column you want to average (“Sales”).
     • The third argument defines the filters (criteria) you want to apply (B3:F4).

3. Result:

   • The formula will return the average sales for the filtered data based on the specified criteria.

Remember to adjust the cell references and column names according to your actual data