Formula help: Crosssheet formula count checkboxes for children only
I'm looking for help with a crosssheet 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!
Best Answer

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:
 The username is not blank.
 The row is a not a parent (using the checkbox column you already have).
 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.
Answers

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:
 The username is not blank.
 The row is a not a parent (using the checkbox column you already have).
 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.

Yes, worked perfectly! Thank you!

Great news. Glad I could help.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!