Need formula for Excel......not easy!!

[FireDesigner]

I need a formula for a spreadsheet. The spreadsheet shows the values for a game. The game has 8 different levels labeled in colum A. In the game there are 10 scores needed to win and it involves 3 players. Colum B labels player 1, Colum C player 2, and Colum D player 3. In these colums the number of scores are entered per game(between 0-10). Ok here is the complicated part. What I am trying to do is get a win percentage per level for each player. In colum A the levels are typed in text. What I need to do is for each level only count the 10's (since a 10 is a win) and divide by the total number of times the level is played for each player. This would give a win % for each player on each level. I am just not sure how to create a formula to find this. Any help is greatly appreciated.

 

[Adnane]

hi,

a suggestion is to use a pivot table and in the data field specify the % of total

hope this helps

 

[SkipVought]

Hi,
I thinks there's some info missing. For instance, for each score in columns B to D what level is associated?

It would help to see your worksheet. Dummy up some data and send it to me and I'll take a look.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com