Array formula - st deviation

Hey guys,

I would need your help, I have a list of 187 countries and I would like to find a way to do this with an array and not by hand.

Attached here is an excel with a sample; I would like to compute the standard deviation of the variable for the period 1980-2008 for each country separately. Is there a way to do this without me having to select by hand the range corresponding to each country in the st dev formula?

Thanks a lot,

Laura.