Averaging and STDev based upon conditions

Hi all,

This may be very simple but I cant think of a way of doing!

I would like to get an average and STDev of a column based around the conditions of another column. I have one column with Country names and another with account balances and I want to look at the average and STDev of the balances if the customer is based in the UK (for example)

Is there an easy way of doing this?

Thanks

is the list (or can it be) sorted by the country? If so, you would be able to use an offset and match formula to define the range you want in the average or stdev function.

=average(offset(b1,match("UK",A:A,0),0,1,1))

I couldn't get either of the above to work, so I actually pivoted the data and did a vlookup of the STDev and Means - thankfully pivot tables allow you to STDev in the metrics!

Thanks for your help guys.