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

  • Staylo95
    Staylo95 ✭✭✭✭
    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

  • Staylo95
    Staylo95 ✭✭✭✭
    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?


  • 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
    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?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!