Add How Many Names Appear in Column Without Using A Formula Using a Specific Name

Janette

I need to track first aid statistics to determine how many employees are responsible for first aid incidents, per month, per location. We have 275 employees and any of those names can appear in the spreadsheet during the year so I don't want to create a formula that will contain that many names. I want to pull information from the original sheet into a separate reference sheet. For example, taking the simplified information from below, how can I show that in December - 3 employees were involved in 4 incidents in Location A, 2 employees were involved in 4 incidents in Location B and 4 employees were involved in 4 incidents in Location C?

Thank you.

Bassam Khalil

Hi @Janette

Hope you are fine, you can use the following formula in the parent level

=COUNT(DISTINCT(CHILDREN()))

Genevieve P.

Hi @Janette

To add to @Bassam.M Khalil's good answer, you'll just need to ensure you're referencing the correct column within the CHILDREN function. If you don't reference any column it will look in the current column, where the formula is placed.

=COUNT(DISTINCT(CHILDREN([Primary Column]@row)))

This formula would be in the current sheet, in a helper column. You could then use cell-links or a cross-sheet reference to bring this data into a second sheet. Will that work for you?

Cheers,

Genevieve