Can I add the number of check boxes together to get a number?

steven.nienaber105336

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:

Staylo95

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?

Staylo95

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?

steven.nienaber105336

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)

Staylo95

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?