Need help with COUNTIF and Percentage
I have a sheet that is counting a range of check marks. Currently in this example there are 25 possible checkmarks and only 22 are checked. The formula I have written has given me the percentage of unchecked, (12%), but I need it to give me the percent checked, (88%).
Here is the formula:
=COUNTIF([24/7 Care Line Helper]@row:[The Capacity Model TCM 101 Helper]@row, 1) / COUNTIF([24/7 Care Line Helper]@row:[The Capacity Model TCM 101 Helper]@row, 0) / 100
Please help! Thanks!
Help Article Resources
Check out the Formula Handbook template!