COUNTIF formula for multiple ranges.

[speedychaz94]

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

 

[RoryA]

A gentle reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Please Help. Difficulty with COUNTIF formula for multiple ranges.

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...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[speedychaz94]

Sorry for cross posting and not providing links. I got a solution from Please Help. Difficulty with COUNTIF formula for multiple ranges. [SOLVED]