Excel question
Hoping someone can help me. I'm a excel rookie was hoping to do the following.
Basically, I have 20 player sheets. At the bottom of each sheet is an average number cell that will change throughout the week based on rankings. I want to create a master sheet that will only tell me the player name and correlate it with that specific player's average ranking cell and have it update automatically.
Just want to see:
John A - 52
Sam B - 44
Tom J - 55
Because I'm an excel rookie, I looked into consolidation. It's kind of doing what I want, I'm linking the cell back to the master sheet, but then it keeps adding everything up (sum). So John A will correctly display 52, but Sam B will show 96 as it's adding the two up. Tom J will show the sum of all of them. I just want it to display the average number that is on each players' sheet next to their name, but don't see an option for that.
I don't want it add them all up just show the damn number that's in that cell for each player. What the heck am I doing wrong?
|