DAVERAGE help needed

Hey everyone...

So I am working on this project for my information systems class, and I have become stuck on a problem for longer than I would like to admit. In this case study project, we are given a database that features 6 different vendors, the parts they sell, how many they sold to us, how much they sold it for, their A/P terms, shipping terms, and days late (or not late) for each item shipped to us.

My teacher wants to me find the average days late for each of the 8 vendors using the DAVERAGE function, specifically the weighted average for each vendor. I have created a criteria table, attempted to leave a line blank below the column label in the criteria range so that the entire column would be applied to the average, and specified conditions that should have provided me the correct answer. Yet, every time I perform the function, the answer I am given is 1.36, when it should be .03. I am not sure if I made the criteria table incorrectly, if I am supposed to filter the results, if my field entry is wrong, or WHAT! I basically look like a mixture of this guy and this guy

Sorry if the answer to my question is painfully obvious. Before yesterday, I could not even tell you what a criteria table is used for. I have read many different online tutorials, and none seem to provide the answer. I have attached the excel spreadsheet that I am working on and the example sheet provided by the instructor. Any help would be GREATLY appreciated.

Thanks.