Finding and summing an interval in a table

J

Julianohcosta

New Member
Joined
Apr 30, 2013
Messages
12
I'm racking my brain to figure out a formula that, when I type an initial month and year, can find them in this table and return the cumulative index until today or an specified date. Exemple: The cumulative index from Oct/2011 to feb/2012. Then the formula would return 4,29%.

ABCDEFGHIJ KLMNOPQRST
Month/Year
January
February
March
April
May
June
July
August
September
October
November
December

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]1995[/TD]
[TD="align: center"]1996[/TD]
[TD="align: center"]1997[/TD]
[TD="align: center"]1998[/TD]
[TD="align: center"]1999[/TD]
[TD="align: center"]2000[/TD]
[TD="align: center"]2001[/TD]
[TD="align: center"]2002[/TD]
[TD="align: center"]2003[/TD]
[TD="align: center"]2004[/TD]
[TD="align: center"]2005[/TD]
[TD="align: center"]2006[/TD]
[TD="align: center"]2007[/TD]
[TD="align: center"]2008[/TD]
[TD="align: center"]2009[/TD]
[TD="align: center"]2010[/TD]
[TD="align: center"]2011[/TD]
[TD="align: center"]2012[/TD]
[TD="align: center"]2013[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]0,00%[/TD]
[TD="align: center"]2,58%[/TD]
[TD="align: center"]1,73%[/TD]
[TD="align: center"]2,67%[/TD]
[TD="align: center"]2,18%[/TD]
[TD="align: center"]1,46%[/TD]
[TD="align: center"]1,27%[/TD]
[TD="align: center"]1,53%[/TD]
[TD="align: center"]1,97%[/TD]
[TD="align: center"]1,27%[/TD]
[TD="align: center"]1,38%[/TD]
[TD="align: center"]1,43%[/TD]
[TD="align: center"]1,08%[/TD]
[TD="align: center"]0,93%[/TD]
[TD="align: center"]1,05%[/TD]
[TD="align: center"]0,66%[/TD]
[TD="align: center"]0,86%[/TD]
[TD="align: center"]0,89%[/TD]
[TD="align: center"]0,60%[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]3,63%[/TD]
[TD="align: center"]2,35%[/TD]
[TD="align: center"]1,67%[/TD]
[TD="align: center"]2,13%[/TD]
[TD="align: center"]2,38%[/TD]
[TD="align: center"]1,45%[/TD]
[TD="align: center"]1,02%[/TD]
[TD="align: center"]1,25%[/TD]
[TD="align: center"]1,83%[/TD]
[TD="align: center"]1,08%[/TD]
[TD="align: center"]1,22%[/TD]
[TD="align: center"]1,15%[/TD]
[TD="align: center"]0,87%[/TD]
[TD="align: center"]0,80%[/TD]
[TD="align: center"]0,86%[/TD]
[TD="align: center"]0,59%[/TD]
[TD="align: center"]0,84%[/TD]
[TD="align: center"]0,75%[/TD]
[TD="align: center"]0,49%[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]2,60%[/TD]
[TD="align: center"]2,22%[/TD]
[TD="align: center"]1,64%[/TD]
[TD="align: center"]2,20%[/TD]
[TD="align: center"]3,33%[/TD]
[TD="align: center"]1,45%[/TD]
[TD="align: center"]1,26%[/TD]
[TD="align: center"]1,37%[/TD]
[TD="align: center"]1,78%[/TD]
[TD="align: center"]1,38%[/TD]
[TD="align: center"]1,53%[/TD]
[TD="align: center"]1,42%[/TD]
[TD="align: center"]1,05%[/TD]
[TD="align: center"]0,84%[/TD]
[TD="align: center"]0,97%[/TD]
[TD="align: center"]0,76%[/TD]
[TD="align: center"]0,92%[/TD]
[TD="align: center"]0,82%[/TD]
[TD="align: center"]0,55%[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]4,26%[/TD]
[TD="align: center"]2,07%[/TD]
[TD="align: center"]1,66%[/TD]
[TD="align: center"]1,71%[/TD]
[TD="align: center"]2,35%[/TD]
[TD="align: center"]1,30%[/TD]
[TD="align: center"]1,19%[/TD]
[TD="align: center"]1,48%[/TD]
[TD="align: center"]1,87%[/TD]
[TD="align: center"]1,18%[/TD]
[TD="align: center"]1,41%[/TD]
[TD="align: center"]1,08%[/TD]
[TD="align: center"]0,94%[/TD]
[TD="align: center"]0,90%[/TD]
[TD="align: center"]0,84%[/TD]
[TD="align: center"]0,67%[/TD]
[TD="align: center"]0,84%[/TD]
[TD="align: center"]0,71%[/TD]
[TD="align: center"]0,61%[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]4,25%[/TD]
[TD="align: center"]2,01%[/TD]
[TD="align: center"]1,58%[/TD]
[TD="align: center"]1,63%[/TD]
[TD="align: center"]2,02%[/TD]
[TD="align: center"]1,49%[/TD]
[TD="align: center"]1,34%[/TD]
[TD="align: center"]1,41%[/TD]
[TD="align: center"]1,97%[/TD]
[TD="align: center"]1,23%[/TD]
[TD="align: center"]1,50%[/TD]
[TD="align: center"]1,28%[/TD]
[TD="align: center"]1,03%[/TD]
[TD="align: center"]0,88%[/TD]
[TD="align: center"]0,77%[/TD]
[TD="align: center"]0,75%[/TD]
[TD="align: center"]0,99%[/TD]
[TD="align: center"]0,74%[/TD]
[TD="align: center"][/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]4,04%[/TD]
[TD="align: center"]1,98%[/TD]
[TD="align: center"]1,61%[/TD]
[TD="align: center"]1,60%[/TD]
[TD="align: center"]1,67%[/TD]
[TD="align: center"]1,39%[/TD]
[TD="align: center"]1,27%[/TD]
[TD="align: center"]1,33%[/TD]
[TD="align: center"]1,86%[/TD]
[TD="align: center"]1,23%[/TD]
[TD="align: center"]1,59%[/TD]
[TD="align: center"]1,18%[/TD]
[TD="align: center"]0,91%[/TD]
[TD="align: center"]0,96%[/TD]
[TD="align: center"]0,76%[/TD]
[TD="align: center"]0,79%[/TD]
[TD="align: center"]0,96%[/TD]
[TD="align: center"]0,64%[/TD]
[TD="align: center"][/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]4,02%[/TD]
[TD="align: center"]1,93%[/TD]
[TD="align: center"]1,60%[/TD]
[TD="align: center"]1,70%[/TD]
[TD="align: center"]1,66%[/TD]
[TD="align: center"]1,31%[/TD]
[TD="align: center"]1,50%[/TD]
[TD="align: center"]1,54%[/TD]
[TD="align: center"]2,08%[/TD]
[TD="align: center"]1,29%[/TD]
[TD="align: center"]1,51%[/TD]
[TD="align: center"]1,17%[/TD]
[TD="align: center"]0,97%[/TD]
[TD="align: center"]1,07%[/TD]
[TD="align: center"]0,79%[/TD]
[TD="align: center"]0,86%[/TD]
[TD="align: center"]0,97%[/TD]
[TD="align: center"]0,68%[/TD]
[TD="align: center"][/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]3,84%[/TD]
[TD="align: center"]1,97%[/TD]
[TD="align: center"]1,59%[/TD]
[TD="align: center"]1,48%[/TD]
[TD="align: center"]1,57%[/TD]
[TD="align: center"]1,41%[/TD]
[TD="align: center"]1,60%[/TD]
[TD="align: center"]1,44%[/TD]
[TD="align: center"]1,77%[/TD]
[TD="align: center"]1,29%[/TD]
[TD="align: center"]1,66%[/TD]
[TD="align: center"]1,26%[/TD]
[TD="align: center"]0,99%[/TD]
[TD="align: center"]1,02%[/TD]
[TD="align: center"]0,69%[/TD]
[TD="align: center"]0,89%[/TD]
[TD="align: center"]1,07%[/TD]
[TD="align: center"]0,69%[/TD]
[TD="align: center"][/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]3,32%[/TD]
[TD="align: center"]1,90%[/TD]
[TD="align: center"]1,59%[/TD]
[TD="align: center"]2,49%[/TD]
[TD="align: center"]1,49%[/TD]
[TD="align: center"]1,22%[/TD]
[TD="align: center"]1,32%[/TD]
[TD="align: center"]1,38%[/TD]
[TD="align: center"]1,68%[/TD]
[TD="align: center"]1,25%[/TD]
[TD="align: center"]1,50%[/TD]
[TD="align: center"]1,06%[/TD]
[TD="align: center"]0,80%[/TD]
[TD="align: center"]1,10%[/TD]
[TD="align: center"]0,69%[/TD]
[TD="align: center"]0,85%[/TD]
[TD="align: center"]0,94%[/TD]
[TD="align: center"]0,54%[/TD]
[TD="align: center"][/TD]

[TD="align: center"]11[/TD]

[TD="align: center"]3,09%[/TD]
[TD="align: center"]1,86%[/TD]
[TD="align: center"]1,67%[/TD]
[TD="align: center"]2,94%[/TD]
[TD="align: center"]1,38%[/TD]
[TD="align: center"]1,29%[/TD]
[TD="align: center"]1,53%[/TD]
[TD="align: center"]1,65%[/TD]
[TD="align: center"]1,64%[/TD]
[TD="align: center"]1,21%[/TD]
[TD="align: center"]1,41%[/TD]
[TD="align: center"]1,09%[/TD]
[TD="align: center"]0,93%[/TD]
[TD="align: center"]1,18%[/TD]
[TD="align: center"]0,69%[/TD]
[TD="align: center"]0,81%[/TD]
[TD="align: center"]0,88%[/TD]
[TD="align: center"]0,61%[/TD]
[TD="align: center"][/TD]

[TD="align: center"]12[/TD]

[TD="align: center"]2,88%[/TD]
[TD="align: center"]1,80%[/TD]
[TD="align: center"]3,04%[/TD]
[TD="align: center"]2,63%[/TD]
[TD="align: center"]1,39%[/TD]
[TD="align: center"]1,22%[/TD]
[TD="align: center"]1,39%[/TD]
[TD="align: center"]1,54%[/TD]
[TD="align: center"]1,34%[/TD]
[TD="align: center"]1,25%[/TD]
[TD="align: center"]1,38%[/TD]
[TD="align: center"]1,02%[/TD]
[TD="align: center"]0,84%[/TD]
[TD="align: center"]1,02%[/TD]
[TD="align: center"]0,66%[/TD]
[TD="align: center"]0,81%[/TD]
[TD="align: center"]0,86%[/TD]
[TD="align: center"]0,55%[/TD]
[TD="align: center"][/TD]

[TD="align: center"]13[/TD]

[TD="align: center"]2,78%[/TD]
[TD="align: center"]1,80%[/TD]
[TD="align: center"]2,97%[/TD]
[TD="align: center"]2,40%[/TD]
[TD="align: center"]1,60%[/TD]
[TD="align: center"]1,20%[/TD]
[TD="align: center"]1,39%[/TD]
[TD="align: center"]1,74%[/TD]
[TD="align: center"]1,37%[/TD]
[TD="align: center"]1,48%[/TD]
[TD="align: center"]1,47%[/TD]
[TD="align: center"]0,99%[/TD]
[TD="align: center"]0,84%[/TD]
[TD="align: center"]1,12%[/TD]
[TD="align: center"]0,73%[/TD]
[TD="align: center"]0,93%[/TD]
[TD="align: center"]0,91%[/TD]
[TD="align: center"]0,55%[/TD]
[TD="align: center"][/TD]

</tbody>
Plan1​
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
You must log in or register to reply here.

Similar threads

marreco
  • Question Question
Return Vertical number header based horizontal number header and number into a matrix
Replies
3
Views
430
Fluff
Fluff
Lacan
  • Question Question
Very simple and easy question: - How to use Indirect Function + Xlookup with 2 Criteria?
Replies
2
Views
452
Lacan
Lacan
S
  • Question Question
Automatically get the x and y values to calculate a SLOPE
2
Replies
16
Views
2K
DILIPandey
DILIPandey
M
  • Question Question
Sum Blocks of Data
Replies
4
Views
952
mucah!t
M

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top