Hi

An answer from Wales!!!

Try the array formula
{=AVERAGE(IF($A$1:$A$1000="Wales",B2:B101))}
Commit with Ctrl+Shift+Enter and Excel will include the curly braces { }
for you. Do not type them yourself.

Or insert a header row with Country, and Value
Apply DataFilterAutofilter and Select Wales for Column A and use the formula
=SUBTOTAL(1,B2:B1001)

Regards

Roger Govier


nir020 wrote:
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