Do I need to combine hlookup and countif?????

I need to count the head to head results in a poker league. There are 7 players and the league works with points being allocated for all places. I am interested in only the winner and second place. I want to count all the final (tournament poker format games work on a knockout basis until 2 players are left to play for first place) head to head results for each player against every other player. The spreadsheet is set out like a table with names in the leftmost column and then each games results in the adjoining column. Next to each name is the points they got for that game. I need to count each time a players get 10 points and match them to 7 point name for each game. This will give me the number of head to head wins that play has against an apponent. See image for layout of league. I may need to do a number of interim formulas to get the final results - thank you.

How about posting the workbook?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"sharkh" <[email protected]> wrote in
message news:[email protected]...
>
> I need to count the head to head results in a poker league. There are 7
> players and the league works with points being allocated for all
> places. I am interested in only the winner and second place. I want to
> count all the final (tournament poker format games work on a knockout
> basis until 2 players are left ot play for first place) head to head
> results for each player against every other player. The spreadsheet is
> set out like a table with names in the leftmost column and then each
> games results in the adjoining column. Next to each name is the points
> they got for that game. I need to count each time a players get 10
> points and match them to 7 point name for each game. This will give me
> the number of head to head wins that play has against an apponent. See
> image for layout of league. I may need to do a number of interim
> formulas to get the final results - thank you.
>
>
> +-------------------------------------------------------------------+
> |Filename: poker league comp 1.jpg |
> |Download: http://www.excelforum.com/attachment.php?postid=5199 |
> +-------------------------------------------------------------------+
>
> --
> sharkh
> ------------------------------------------------------------------------
> sharkh's Profile:
http://www.excelforum.com/member.php...o&userid=37526
> View this thread: http://www.excelforum.com/showthread...hreadid=571723
>

Here is the file, all current formulas are pretty straight forward, I have had a go at doing the next few steps in approx cell AO20ish. hope you can help.