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
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!