Need help with COUNTIF and Percentage

jhunter91

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!

Leibel S

@jhunter91

=COUNTIF([24/7 Care Line Helper]@row:[The Capacity Model TCM 101 Helper]@row, 1) / 25