Without DAverage

=AVERAGE(IF(B1:B1000="Wales",C1:C1000))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nir020" wrote in message
...
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