I have a spreadsheet where I want to express a progress bar of how many fields have "Yes" marked in them. The yes is entered in fields with Data Validation on them.
I've used the formula =COUNTA(C4:C78)/((COUNT(C4:C78))+(COUNTBLANK(C4:C78))) however the output is coming up with an incorrect percentage. As the example shows below there are 36 out of 75 cells marked with Yes which is 48%, however the formula is returning 92%. Is there any other formula that will provide me and accurate result?
<tbody>
</tbody>
I've used the formula =COUNTA(C4:C78)/((COUNT(C4:C78))+(COUNTBLANK(C4:C78))) however the output is coming up with an incorrect percentage. As the example shows below there are 36 out of 75 cells marked with Yes which is 48%, however the formula is returning 92%. Is there any other formula that will provide me and accurate result?
# of Days | Date Required | Complete (Y/N) |
92% | ||
131 | Monday, 02 March 2015 | |
131 | Monday, 02 March 2015 | |
262 | Tuesday, 01 September 2015 | |
5 | Friday, 05 September 2014 | |
5 | Friday, 05 September 2014 | |
5 | Friday, 05 September 2014 | |
5 | Friday, 05 September 2014 | |
66 | Monday, 01 December 2014 | |
131 | Monday, 02 March 2015 | |
131 | Monday, 02 March 2015 | |
301 | Tuesday, 25 August 2015 | Yes |
81 | Tuesday, 21 October 2014 | Yes |
81 | Tuesday, 21 October 2014 | Yes |
81 | Tuesday, 21 October 2014 | Yes |
81 | Tuesday, 21 October 2014 | Yes |
81 | Tuesday, 21 October 2014 | Yes |
81 | Tuesday, 21 October 2014 | Yes |
81 | Tuesday, 21 October 2014 | Yes |
81 | Tuesday, 21 October 2014 | Yes |
81 | Tuesday, 21 October 2014 | Yes |
0 | Yes | |
0 | Yes | |
0 | Yes | |
21 | Monday, 29 September 2014 | |
0 | Yes | |
21 | Monday, 29 September 2014 | |
0 | Yes | |
21 | Friday, 29 August 2014 | |
21 | Friday, 29 August 2014 | |
21 | Friday, 29 August 2014 | |
21 | Friday, 29 August 2014 | |
49 | Friday, 29 August 2014 | Yes |
49 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | Yes |
44 | Friday, 29 August 2014 | Yes |
15 | Friday, 29 August 2014 | |
15 | Friday, 29 August 2014 | |
15 | Friday, 29 August 2014 | Yes |
15 | Friday, 29 August 2014 | Yes |
15 | Friday, 29 August 2014 | Yes |
15 | Friday, 29 August 2014 | Yes |
15 | Friday, 29 August 2014 | Yes |
15 | Friday, 29 August 2014 | Yes |
9 | Friday, 29 August 2014 | Yes |
5 | Friday, 29 August 2014 | |
3 | Friday, 29 August 2014 | |
110 | Monday, 01 December 2014 | |
110 | Monday, 01 December 2014 | |
44 | Friday, 29 August 2014 | Yes |
44 | Friday, 29 August 2014 | Yes |
44 | Friday, 29 August 2014 | Yes |
44 | Friday, 29 August 2014 | Yes |
44 | Friday, 29 August 2014 | Yes |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | Yes |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | Yes |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | |
44 | Friday, 29 August 2014 | Yes |
44 | Friday, 29 August 2014 | Yes |
44 | Friday, 29 August 2014 | Yes |
44 | Friday, 29 August 2014 | Yes |
<tbody>
</tbody>