Countif for parent rows

jjesmith

I would like the formula to count all checkboxes of parent rows in a column.

Paul Newcome

Are you able to provide a screenshot for reference?

Ipshita

Hello @jjesmith

Here is your solution -

=COUNTIF(Check:Check, "1") check the solution in Column25 below

Cheers!

Ipshita

jjesmith

Thank you both for response. The formula Ipshita provides counts all checkboxes in the enter column not just the Parent Rows.

My sheet has Child rows under the Parent rows that each also have check boxes. If any one of the child rows are checked then the Parent row is checked. I want to add those checkboxes in the Parent rows only. So in this example pasted below the answer would be three (3).

Paul Newcome

In this case you would need a helper column that designates which rows are parent rows (can be hidden after setting up).

=IF(COUNT(CHILDREN([Employee Requirement]@row))> 0, 1)

Then to get the count of checked parent rows you would use

=COUNTIFS(OSHA:OSHA, @cell = 1, Helper:Helper, @cell = 1)