Percentage on dynamic range

Hi

On sheet 2 I would like a formula that works out a percentage based on a dynamic range, is this possible?

e.g. I could have a list of N number of people and the formula would need to be smart enough to know how many “Y” appear against the number of people listed

In the examples provided I have 10 people listed where I would need the formula to return 50% (5 people have “Y”) and in the 2nd example only one person out of 4 has a “Y” so this would need to be 25%.

The range could be anything from 1 to 100 people.

Can anyone help please?

Managed to do it with this:
=COUNTIF($E$8:$E$17,"Y")/COUNTA($D$8:$D$17)