% Complete for Checkboxes Marked
Hello, I've looked into similar questions, but I'm struggling in how to write the formula for this. I'd like to calculate % complete of checkboxes marked for each column. Then I plan to represent the % complete in either a dashboard for reporting purposes. From what I read, it should be the =countif formula, but cannot seem to figure out. I appreciate the help!
Answers

Hi @GiselleF,
You can use a formula like this:
=COUNTIF([Ann Arbour Terminal 1]:[Ann Arbour Terminal 1], 1) / COUNT(Date:Date)
For the other terminals just adjust the column name in the COUNTIF.
This will give you a decimal number which you can convert to a decimal in a column using the button in the toolbar, or you can adjust the formula slightly if you want it directly (for example, in a sheet summary) like so:
=(COUNTIF([Ann Arbour Terminal 1]:[Ann Arbour Terminal 1], 1) / COUNT(Date:Date)) * 100 + "%"
Hope this helps, but post if you have any problems/questions!
Help Article Resources
Categories
Check out the Formula Handbook template!