Please help

I want to work an average percent from a list of percents in column C row
1-1000 where the value of column B is equal to "Wales". The frequency of
Wales is too large for to manually select the cells so how can I employ the
Daverage function to calculate this,

Thanks