I might kick myself when I see a proper solution but here goes....
I need to determine percentage in rows where the total number of cells being added will change.
Normally, I would use the old formula: =SUM(D29:D43)/15 - where I add up the values (in this case either 1 or 0 value) and divide by the sum of all the cells (15). However, this is inconvenient when the value of 15 may change.
If I use the formula =AVERAGE(D4:D13) the problem with the changing number of cells is solved, however, the value is slightly different (re: only the average value).
Can someone please provide a solution to this problem?