I am trying to put together an average function using index match. I have entered the formula into cell c18 on the "team rankings" tab. However that is not the correct average when I calculate it manually. The data I am trying to average is found on the "weekly team stats" tab.
Can someone please help me with this formula??
Bookmarks