Counting Checkboxes NOT Checked within a Specific Range for Sheet Summary

Nancy Heater
Nancy Heater ✭✭✭✭
edited 10/02/20 in Formulas and Functions

Hello all and Happy Friday!

I need to count the number of checkboxes that are NOT checked within a given range in a column.

I have found formulas to count checkboxes NOT checked for an entire column, that seems to also count all "blank" cells below my data range, so its providing incorrect counts.

Example sheet is linked below. I would like to count the number of boxes NOT checked for rows 1 - 249, and then NOT checked for my entire data range, which currently is thru row 562, for the Sheet Summary Fields I have set up. https://app.smartsheet.com/b/publish?EQBCT=2a8f00cc49eb4021916f06af91e28095

Thank you in advise for your assistance.

Best Answers

  • Nancy Heater
    Nancy Heater ✭✭✭✭
    edited 10/02/20 Answer ✓

    Figured it out ... had to put in brackets and put the range numbers outside the brackets to count non checked cell for a specific row range, in this case, Rows 1 - 1434.

    =COUNTIF([MPU w Rollout]1:[MPU w Rollout]1434, 0)

    Not really sure why it worked on one sheet one way and not on another, but at least we have (2) options to try!

    The version of =COUNTIF([MPU w Rollout]:[MPU w Rollout], 0) to count all non-checked for the entire row stills counts more rows than there is data for, so that one still is problematic, but the above solution works for what I needed.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!