Can I add the number of check boxes together to get a number?
I have 8 check boxes I need to add together to ultimately get a percentage complete. E.g., if 8 boxes are checked, 100%, 4 boxes checked, 50%, etc...
Here is a screen shot of the formula I built so far, but it's incorrect:
Best Answer

Hi Steven,
I recreated the description of your problem statement and came up with this:
=SUM(COUNTIF([Check 1]@row:[Check 3]@row, 1) / 3)
This formula counts the number of boxes in the specified range (Check 1 to Check 3) which are checked, and divides it by 3 to give me the percent.
Does this answer your question?
Answers

Hi Steven,
I recreated the description of your problem statement and came up with this:
=SUM(COUNTIF([Check 1]@row:[Check 3]@row, 1) / 3)
This formula counts the number of boxes in the specified range (Check 1 to Check 3) which are checked, and divides it by 3 to give me the percent.
Does this answer your question?

It sure does! Thank you!
Now, I want to add vertically, which I know I can do with this formula when the cells are all in a row: =SUM(COUNTIF([Minneapolis Task Complete]2:[Minneapolis Task Complete]4, 1) / 3)
However, what if I want to add cells that are not in a consistent row? In this case, I want to sum rows 2 and 4. Was not successful with this formula: SUM(COUNTIF([Minneapolis Task Complete]2,+[Minneapolis Task Complete]4, 1) / 2)

I think this will solve it =SUM(COUNTIF([Check 1]6, 1) + COUNTIF([Check 1]3, 1)) / 2
Each of those cells needs to be counted individually. Is there another column with supporting data that would allow you to use countifs?
If this doesn't work can you add another screenshot example of the problem?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!