$=$DAVERAGE$($ Table$1,$ "Quantity" $,$ Criteria!B$1$:B$2)$ Is an example of a "database" function that will look at everything in the Excel table called Table$1,$ filter the rows based on the criteria found on the Criteria sheet in B$1$ through B$2,$ and take an average of the numbers found in the column with the Quantity heading.