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.
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) |