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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!