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.

Ah, okay, well that definitely helped, and my new answer is closer to the one I am looking for, but it is still not figuring the entire column into the equation, just the specific vendor number amount. I am trying to divide -4 by 128, not 15. Do I need to enter a blank line below the column labels in the criteria range?

Thanks for all the help!

Ah, okay, well that definitely helped, and my new answer is closer to the one I am looking for, but it is still not figuring the entire column into the equation, just the specific vendor number amount. I am trying to divide -4 by 128, not 15. Do I need to enter a blank line below the column labels in the criteria range?

Thanks for all the help!

The 128 should be the denominator. My instructor wants me to find the average days late for each vendor out of the entire amount of days late. The answer I have right now is -0.26667, and I need -.03. I am sure there are other ways I can come to this answer, but for the the project, I have to use the daverage function.

I'm really not sure what to do. Do I try to make a table? Filter results? Use a sum function???? AHHH

The 128 should be the denominator. My instructor wants me to find the average days late for each vendor out of the entire amount of days late. The answer I have right now is -0.26667, and I need -.03. I am sure there are other ways I can come to this answer, but for the the project, I have to use the daverage function.

I'm really not sure what to do. Do I try to make a table? Filter results? Use a sum function???? AHHH

annndd just like that, I figured it out. Thanks for all the help mrice!

Another question...I found out the averages for the other vendors by using data tables, but how would I find the average for each individual vendor otherwise?

Also, I need to use the DMAX function to rank the vendors by the best A/P terms...from highest to lowest. I use the same database, but a different criteria and field...do I need to set up another criteria table?

Sorry for all the questions. The teacher wants us to "really learn how to do this", so he did not explain how it's done.