Formula help: Cross-sheet formula count checkboxes for children only

Lisa Wood

I'm looking for help with a cross-sheet formula that counts selected checkboxes in a column but only counts child rows, and only where the user name is not blank.

I have a checkbox column for Parent and also a helper column identifying parent numerically (0/1). I haven't been able to figure out a formula that works. Any help appreciated!

KPH

I think a COUNTIFS formula will do what your need. You can include multiple criteria and the formula will count where all are true.

Your criteria will be:

1. The username is not blank.
2. The row is a not a parent (using the checkbox column you already have).
3. The checkbox you want to count is checked.

So, if your data looked like this:

The formula would be:

=COUNTIFS({Reference to Name column}, <>"", {reference to is parent column}, 0, {reference to boxes to count column}, 1)

Hope that helps.

KPH

I think a COUNTIFS formula will do what your need. You can include multiple criteria and the formula will count where all are true.

Your criteria will be:

1. The username is not blank.
2. The row is a not a parent (using the checkbox column you already have).
3. The checkbox you want to count is checked.

So, if your data looked like this:

The formula would be:

=COUNTIFS({Reference to Name column}, <>"", {reference to is parent column}, 0, {reference to boxes to count column}, 1)

Hope that helps.

Lisa Wood

Yes, worked perfectly! Thank you!

KPH

Great news. Glad I could help.