Ok, so I used the "COUNTIF" formula to give texts within a chart values such as 1,2,3, etc depending on where they are in the chart. For example:


QB RB RB2 WR TE FLEX D/ST K
1 X Y W A B A C X
2
3
4
5
6
7
8
9
10
11
12

This is for a fantasy football league. The teams would fill up the chart. There are 12 different "TEAMS" within the chart, and each column has one of each "TEAM". This is simply a ranking chart from best (1) to worst (12). So using my "COUNTIF" formula, I have created a way to add up all the values to give me a whole number. I then use this whole number and divide it by 9 (the amount of positions along the x-axis) to give me the average ranking for each "TEAM". An example of my "COUNTIF" formula:

=(COUNTIF($B18:$J18,"LEVS")+COUNTIF($B19:$J19,"LEV S")*2+COUNTIF($B20:$J20,"LEVS")*3+COUNTIF($B21:$J2 1,"LEVS")*4+COUNTIF($B22:$J22,"LEVS")*5+COUNTIF($B 23:$J23,"LEVS")*6+COUNTIF($B24:$J24,"LEVS")*7+COUN TIF($B25:$J25,"LEVS")*8+COUNTIF($B26:$J26,"LEVS")* 9+COUNTIF($B27:$J27,"LEVS")*10+COUNTIF($B28:$J28," LEVS")*11+COUNTIF($B29:$J29,"LEVS")*12)/9

(if there was a simpler way of doing this, I would like to know that too, but as of now I am set with this formula)

The thing is, each position along the x-axis has a certain weighted value that I would like to incorporate into the formula. For example, when your QB outscores your opponents QB in a given week, you have a 63.89% chance of winning the game. So how do I correctly insert this percentage? Or, should I give a whole number value to each position (i.e. RB1=1, FLEX=2, etc.)? What would be more accurate?

This my first post, so I'm not sure if I can actually upload the spreadsheet. I will if I can, but I do not see an option to do so. In the "COUNTIF" example I posted above, the number that comes out is "3.33". The weighted average that I am looking for is "2.02" when using winning percentage as the weight.

I'm not entirely sure if I explained this correctly, so if there is any confusion I would be more than happy to clarify. Thanks for your help!


--Cory