Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 -- James. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Concatenating Relevant Headings | Excel Discussion (Misc queries) | |||
creating formulas which ignore text in the relevant cells | Excel Discussion (Misc queries) | |||
summing the relevant columns | Excel Discussion (Misc queries) | |||
Adding relevant sheets | Excel Worksheet Functions | |||
Remove cells with text not relevant | Excel Worksheet Functions |