Running Percentage Average.

[Ev1lZer0]

I am trying to get an average percentage based on all the above cells.

For instance:
Cell K2 shows 62.2% I need L to execute the formula of =SUM($K$2)/1
Cell K3 shows 59.3% I need L3 to execute the formula of =SUM($K$2:$K3/2)
Cell K4 shows 64.0% I need L4 to execute the formula of =SUM($K$2:$K3/3)
and so on.

I can get the sum portion to work correctly when extending the table to add more rows, but I can't get the divided by portion to automatically add one.

Juror Percentages.xlsx
	K	L
1	% show up	Column1
2	62.2%	62.2%
3	59.3%	60.8%
4	64.0%	61.9%
5	70.4%	64.0%
6	63.9%	64.0%
7	53.8%	186.9%
8	65.7%	146.5%
9	47.5%	121.8%
10	65.8%	110.6%
11	66.4%	309.6%
12	57.6%	225.6%
Sheet1

Cell Formulas
Range	Formula
K2:K12	K2	=IF(J2,J2/F2,"N/A")
L2	L2	=SUM($K$2)/1
L3,L7,L11	L3	=SUM($K$2:$K3/2)
L4,L8,L12	L4	=SUM($K$2:$K4/3)
L5,L9	L5	=SUM($K$2:$K5/4)
L6,L10	L6	=SUM($K$2:$K6/5)

 

[Oaktree]

=SUM($K$2:$K2)/COUNTA($K$2:$K2)

 

[mikerickson]

Typically averaging averages gives misleading results unless the base total population of each of the averages being averaged is the same.

 

[Ev1lZer0]

Thank you, it was simpler than I thought. Much appreciated!

=SUM($K$2:$K2)/COUNTA($K$2:$K2)