I have a dataset that includes year, country, and population data. A small condensed sample is below.
I am trying to write an excel statement that would calculate the average population from 1980 - 1985 depending on the country. There are only two in the sample chart but the dataset includes over 145 unique countries. The Year column repeats a sequence from 1980 - 2014 for each country and I am having trouble deciding which function would be best to solve this problem. Any ideas?