speedychaz94
New Member
- Joined
- Dec 7, 2020
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hello.
As you'll be able to gather, I am no excel expert, but I do enjoy learning new excel formulas. I hope someone will be able to help me with this one.
I have been running a private fantasy football (soccer for many) league for many years using excel to document the league table. Each month we have awards for managers that achieve the highest monthly total. I am now trying to create a tally for each manager on how many monthly awards they have had. Attached is a rough example of what my data looks like. In B3:B13 I would like a formula to calculate how many times manager names appears in cells G16, K16, R16, U16, X16 & AB16. Ordinally this would be simple formula, but I need it to be a partial match because occasionally two names appear for when it is a tie. Also, in my original document these cell references are in another workbook, so I get a #Value! error when I close the associated workbook whenever I use the countif formula.
I do hope this makes sense and that someone can help.
Many Thanks
Charlie
As you'll be able to gather, I am no excel expert, but I do enjoy learning new excel formulas. I hope someone will be able to help me with this one.
I have been running a private fantasy football (soccer for many) league for many years using excel to document the league table. Each month we have awards for managers that achieve the highest monthly total. I am now trying to create a tally for each manager on how many monthly awards they have had. Attached is a rough example of what my data looks like. In B3:B13 I would like a formula to calculate how many times manager names appears in cells G16, K16, R16, U16, X16 & AB16. Ordinally this would be simple formula, but I need it to be a partial match because occasionally two names appear for when it is a tie. Also, in my original document these cell references are in another workbook, so I get a #Value! error when I close the associated workbook whenever I use the countif formula.
I do hope this makes sense and that someone can help.
Many Thanks
Charlie