Count boxes checked based on specific data in another row

Nancy Heater
Nancy Heater ✭✭✭✭
edited 08/20/21 in Formulas and Functions

Hi all!

I have columns labeled "Inside" and "Outside" that are check boxes.

I have another column for "Install Status".

In my Summary data, I need to count the number of Status that are "Complete" that are checked for "Inside", and the number of "Complete" that are check for outside.

I tried this but is not working:


Testsheet link:

Thanks in advance for the help, as always!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!