Original: A Learning case caused by calculating the average purchase price

Original: A Learning case caused by calculating the average purchase price

Background:
I received a call from a finance friend a few days ago, "said he wanted to help calculate the average unit price of a vegetable purchase. If the leader's requirements are urgent,About 2-3 hoursTo see if there is a simple way to quickly count ";
At that time, I was not very busy. I asked my friend to send the original file. After a simple analysis, I thought that the sumproduct function in excle could be implemented through the sum calculation of multiple conditions; it took about five minutes to complete the work, which was exactly what a friend wanted;
Inspiration:
Later, I thought that this case was a classic story. I used the most unique secret in the field for so many years. Why not make a video so that more friends can learn and understand it; so we have the following video tutorial;
Tutorial:

Http://v.qq.com/page/v/7/r/v01313hbq7r.html

Postscript:
If you want to follow the operation steps in the video and practice on your own, you can add QQ (2118917071) and I will send you the original Excel file. Of course, if you have any questions during the exercise, feel free to consult;
Investigation:

If you have other suggestions, please feel free to contact me (excel_cortana) or QQ (2118917071;