Hi Guys,
I'd like to seek help in the sample table I have created as attached. While I understand that I can use Sumproduct to calculate the weighted average of a weight and a score, what formula should I be using to calculate the weighted average of say 5 days to calculate the End of Week weighted average? I was hoping that my data will not show an average of an average that's why I thought of using sumproduct but I am stuck with how I can get the end result for a week's data.
Appreciate any help.
Bookmarks