Countif range from multi select contains (value) under each parent from another sheet

Julie Castell

I need a cross reference formula using countif a specific value in a multi select column is under a parent from another sheet.

Paul Newcome

You cannot reference hierarchies directly with cross-sheet references. You would need to calculate those values on the source sheet, then pull them to your target sheet.