Trying to format one cell to match data in two cells and input data from third cell

[Ghostcoy]

I am curently trying to format a spreadsheet to keep a reacord of my dart teams stats, and need a little help with a some formating. we have 6 players and play a 3 2 1 (that is 2 x 3 players, 3 x 2 Players and 6 x 1 player format) players are selected randomly each playing 1x1 leg triples, 1x1 leg doubles and 1x3 leg singles. At the bottom of the sheet I have the total stats for the night, what I would like to do is, in cell G35, if the name in, say, cell B7, B8 or B9 is the same as cell B35 then enter the data or value from cell E27,D27 or B27 respectivly, or in cell I35 if the name in L,N,Q,S,V or X7 is the same as B35 then enter data or value from cell M,O,R,T,W or Y27 respectivly, and in the case of the singles in cell L35 if cell AA,AF,AK,AP,AU orAZ7 is the same as B35 then enter the data or value from cells (AV27,AW27 and AX27) in the caes of AU27 for example. Sory if it seems a bit long winded, can do simple stuff but this one is a bit beyond me!!!

[NBVC]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Ghostcoy]

Thank you NBVC, new to help forum, was not sure how to discribe my problem, brain getting tired, trying to sort it out

[Huron]

Hi Ghostcoy

Could you post a copy of your workbook (cleared of any sensitive information)? Click Go Advanced then Manage Attachments.

[Ghostcoy]

Hi Huron

Hope you can see what I am trying to do! Trying to match names of players, which can be in any one of 6 cells, in any of the three types of game, then input the total score and shots into the corisponding cell in the grid below. what I would also like to do is that when a player gets a peg it records 1 for each pegout in that grid. Hope I'm not trying to get it to do too much!

[Huron]

I've linked cells in row 50 to the names which appear in rows 7,8 & 9 to show the players' names on a single row in the same columns as their scores so that they can be used in SUMIF formulas to give the results you need. See the attached file.

I'm not sure what you are asking for in your last post. I'm not a darts player - can you explain getting a peg and pegout?

[Ghostcoy]

Hi Huron

Thanks mate! Didn't think of that one. Ok a peg or pegout is the last dart or darts thrown in a leg, to finish on a double, this is counted as 1 on a stats sheet, not the actual score that was pegged out with. So if a player, say, as in the case of, Teaea pegged out in 4 legs on the night, 1 in the triples, 1 in the doubles, and 2 in the singles, not 144 times as in the stats at the moment. Just checked wk2 and changed a couple of names around in rows 7,8 & 9 and it works great.

[Huron]

As you're using Excel 2007 you can use COUNTIFS to get the number of pegouts.

Change the formula in V38 to

= COUNTIFS($C$50:$BC$50,$B38,$C$29:$BC$29,">0")

and copy it down.

[Ghostcoy]

Hi Huron

You Bute! Works a treat, Thanks for all your help!