Even if you've never used SUMPRODUCT before, you'll be able to use it like a pro by the end of this article. For these situations, you'll need to calculate the weighted average.Īlthough Excel doesn't have a weighted average function, it does have a function that does most of the work for you: SUMPRODUCT. But what if some of the values have more "weight" than others? For example, in many classes the tests are worth more than the assignments. en/excel-tips/how-to-use-excels-vlookup-function/content/ Use SUMPRODUCT to calculate weighted averagesĮxcel makes it extremely easy to calculate the average of several cells: Just use the AVERAGE function. Lesson 20: Use SUMPRODUCT to Calculate Weighted Averages
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |