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
Check out the Formula Handbook template!