Count the number of check marks in a column for a section of rows


Hi Folks,

I want to count the number of check marks there are in rows in a section of rows. These rows have a column with the same name, so there is a reference. So if column "Section" says "Story Name" and there are seven rows that have the same story name, and there is a check mark column where only 6 of the 7 rows are check, I want a formula to return 6.

Any advice?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!