Oops!!

Thank you Bob.
Because I had inserted a row to use the Subtotal function, I copied the
wrong range to my answer. You are quite right it should have been
the array formula
{=AVERAGE(IF($A$1:$A$1000="Wales",$B$1:$B$1000))}

Lucky the English are wide awake!!!

Regards

Roger Govier


Bob Phillips wrote:
Be aware that this will probably give a wrong answer as it uses the amount
in B2 when A1 equals Wales. For some reason, Roger shifted the second range
down by a row.