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?
Thanks,
Michael
Answers
-
Something like this should work
=COUNTIFS([Section]:[Section], "Story Name", [Check]:[Check], 1)
You will have to modify the range if you are pulling from another sheet
=COUNTIFS({Section}, "Story Name", {Check}, 1)
Did that work?
-
Thanks so much for your suggestion. I'm closer in that I'm not getting an error, but it's not correct, yet. I'll keep working on it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!