Juicey27
09-08-2010, 01:19 PM
:dunno In column C i want to do two things:
(1)FORMAT COLUMN C > All numbers entered are formated in percentages. (no spaces after decimal) The formula that generates these percentages is in each cell of column C. It is . .
=SUM(F5:M5)/8
(2)Secondly, I want to obtain a running average of the entire column C
Problem I have now is that when I go to average all cells in column C, it averages in the 0% from having formatted the column to display percentage.
In cel N1 is where my formula is for averaging column C
=AVERAGE(C:C)
Please help . . thanks in advance
(1)FORMAT COLUMN C > All numbers entered are formated in percentages. (no spaces after decimal) The formula that generates these percentages is in each cell of column C. It is . .
=SUM(F5:M5)/8
(2)Secondly, I want to obtain a running average of the entire column C
Problem I have now is that when I go to average all cells in column C, it averages in the 0% from having formatted the column to display percentage.
In cel N1 is where my formula is for averaging column C
=AVERAGE(C:C)
Please help . . thanks in advance