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

Michael Stanton

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

bcwilson.ca

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?

Michael Stanton

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.