Forum Discussion
count and percentages
Please see attached example. Each column can have a range of results of either "Yes", "No" or "NA". Row 23 is supposed to give the total % complete (ie the Number of "Yes" plus the number of "NA" com...
In B23:
=COUNTIF(Table1[Is the clinical indication stated in the patients record?],"<>NO")/COUNTA(Table1[Is the clinical indication stated in the patients record?])
Fill to the right.
The result will be 100% in all columns, since there are no NO replies in your sample workbook.
thank you HansVogelaar. That has worked a treat.
