Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

Jayems · 09-27-2015, 04:07 PM

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?

09-27-2015, 04:07 PM	#1
Jayems Franchise Player Join Date: Aug 2005 Location: Calgary Exp:	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?