Reference Sheet with Parent/Child Rows and Multi-Select
Sheet 1 - A sheet that contains parent and children rows with columns containing multi-selects.
Sheet 2- A summary sheet that references Sheet 1. I want to count the children rows of the conditions:
a) Team Red
b) Area only has "West" included.
I think I use COUNTIFS, but not sure how to reference another sheet and only include Children of a specific parent.
Help Article Resources
Check out the Formula Handbook template!