![]() If you'd like to follow along, you can download our example. The method we're using works with all versions of Excel, and it also works with other spreadsheet applications like Google Sheets. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |