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?
[TABLE="class: grid, width: 371"]
<tbody>[TR]
[TD="colspan: 3"][/TD]
[/TR]
[TR]
[TD]# of Days[/TD]
[TD]Date Required[/TD]
[TD]Complete (Y/N)[/TD]
[/TR]
[TR]
[TD="colspan: 3"]92%[/TD]
[/TR]
[TR]
[TD]131[/TD]
[TD]Monday, 02 March 2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]131[/TD]
[TD]Monday, 02 March 2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]262[/TD]
[TD]Tuesday, 01 September 2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Friday, 05 September 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Friday, 05 September 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Friday, 05 September 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Friday, 05 September 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]66[/TD]
[TD]Monday, 01 December 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]131[/TD]
[TD]Monday, 02 March 2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]131[/TD]
[TD]Monday, 02 March 2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]301[/TD]
[TD]Tuesday, 25 August 2015[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Monday, 29 September 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Monday, 29 September 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]49[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]49[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]110[/TD]
[TD]Monday, 01 December 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]110[/TD]
[TD]Monday, 01 December 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]
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?
[TABLE="class: grid, width: 371"]
<tbody>[TR]
[TD="colspan: 3"][/TD]
[/TR]
[TR]
[TD]# of Days[/TD]
[TD]Date Required[/TD]
[TD]Complete (Y/N)[/TD]
[/TR]
[TR]
[TD="colspan: 3"]92%[/TD]
[/TR]
[TR]
[TD]131[/TD]
[TD]Monday, 02 March 2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]131[/TD]
[TD]Monday, 02 March 2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]262[/TD]
[TD]Tuesday, 01 September 2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Friday, 05 September 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Friday, 05 September 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Friday, 05 September 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Friday, 05 September 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]66[/TD]
[TD]Monday, 01 December 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]131[/TD]
[TD]Monday, 02 March 2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]131[/TD]
[TD]Monday, 02 March 2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]301[/TD]
[TD]Tuesday, 25 August 2015[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]81[/TD]
[TD]Tuesday, 21 October 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Monday, 29 September 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Monday, 29 September 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]49[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]49[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]110[/TD]
[TD]Monday, 01 December 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]110[/TD]
[TD]Monday, 01 December 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]Friday, 29 August 2014[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]