Excel Count Function

Question

In the reference example below, I tried using the "IF" or the "Count" function to count the number of players scores in cells A2:A7, B2:B7 that  are > the least players scores from A15:A25, B15:25 enter the result in cell "Total Points" B12; How can I obtain a result using the "Count, IF, or the VLOOKUP function?

LeRoy

TEAM - PLAYERS	GAME 1
PLAYER 1	130
PLAYER 2	173
PLAYER 3	209
BONUS PINS
TOTAL POINTS	1
TEAM - PLAYERS	GAME 1
PLAYER 7	202
PLAYER 8	235
PLAYER 9	195

Answer 1

Please see the attached example, what I am trying to do is to count all the player scores with highest to count as (1) from players 1-7 in game 1, against players score from7-8 game 1.  I am also trying count a tie score as a .5 if a score equal another between the players. 

I am trying to count the "Total" score as 2 depending on the highest score, and a count of 1 if the "Total" scores are equal. 

My maximum "Total Points" is 7 between the two groups. Cells are B2:B:9 Team 1, B15:B22 Team 2.

Thanks, I hope this will help.

TEAM - PLAYERS	GAME 1	GAME 2
PLAYER 1	202	204
PLAYER 2	173	217
PLAYER 3	209	200
PLAYER 4	179	167
PLAYER 5	165	226
PLAYER 6
TOTAL	928	1014
BONUS PINS
TOTAL POINTS	2	2
TEAM - PLAYERS	GAME 1	GAME 2
PLAYER 7	202	258
PLAYER 8	236	211
PLAYER 9	195	256
PLAYER 10	201	229
PLAYER 11	193	211
PLAYER 12
TOTAL	1027	1165
BONUS PINS
TOTAL POINTS	6	6

Answer 2

Now that your query has changed, I suggest you take sample example(s) to explain and also show your desired result with appropriate layout.

Answer 3

Try the following formula in the cell B12

=COUNTIF(B2:B7,">"&MIN(B15:B25))

Hope this Helps.

Try the following formula in the cell B12

=COUNTIF(B2:B7,">"&MIN(B15:B25))

Hope this Helps.

Yes, it was helpful, but it did not solve the problem I am having.  I ask my question the wrong way, I am trying to count each player with the highest scores in B2:B7 as 1 each against the possible player scores in B15:25; and to count a possible tie score as .5 if there matching score; the MAX points much = to 5 points for the players. 

My maximum total points much = 7 point (for the players and total) including 2 points (and/or 1 point if there's a tie score) for the highest "Total score" 

Thanks

Answer 4

Thank you for the excellent help you provided it work's perfectly;  However, I have an addition question related to the reference formula.  Using that same formula, how can I include a 1/2 (.5) point if a score = to another within the group. 

Thank you, again for the wonderful and excellent support.

Answer 5

Try the following formula in the cell B12

=COUNTIF(B2:B7,">"&MIN(B15:B25))

Hope this Helps.