J
James
Hi all
I have a list of months and % attributed to those months for a number of
countries in a spreadsheet (see below) elsewhere I have a sheet with a list
of countries with various start and end dates.
COUNTRY Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08
Albania 22% 20% 10% 17% 6% 0%
Antarctica 0% 0% 0% 0% 0% 0%
Argentina 4% 4% 2% 3% 6% 6%
What I want to do is for example where I know the country is Argentina, the
start month is Feb-08 and end month is May-08 I want it to add the %s up i.e.
15%.
Thanks in advance
I have a list of months and % attributed to those months for a number of
countries in a spreadsheet (see below) elsewhere I have a sheet with a list
of countries with various start and end dates.
COUNTRY Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08
Albania 22% 20% 10% 17% 6% 0%
Antarctica 0% 0% 0% 0% 0% 0%
Argentina 4% 4% 2% 3% 6% 6%
What I want to do is for example where I know the country is Argentina, the
start month is Feb-08 and end month is May-08 I want it to add the %s up i.e.
15%.
Thanks in advance