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

On Wednesday, 23 April 2014 00:09:35 UTC+10, wrote:
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

I'm confused by your use of the word "chart". This normally refers to a graph or pie chart or column chart or some graphical representation of data, but it looks as if you mean data set out in a table or on a worksheet. Is that what you mean?

Howard

On Wednesday, April 23, 2014 12:49:27 AM UTC-4, Howard Silcock wrote:
On Wednesday, 23 April 2014 00:09:35 UTC+10, wrote:

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



I'm confused by your use of the word "chart". This normally refers to a graph or pie chart or column chart or some graphical representation of data, but it looks as if you mean data set out in a table or on a worksheet. Is that what you mean?



Howard

Thanks for the reply, Howard. Yes, I meant table instead of chart. It is simply a table that I am pulling this data from.