Doug Van
asked on
Getting percentages (in Excel 2010) while having dynamic number of values?
Hello folks,
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?
Thanks,
Rod
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?
Thanks,
Rod
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I could not make the bottom formula work but the rest did..
:-)