Adding a range
 

I have one sheet in Excel 2003 that is the main sheet and a hidden sheet with
weeks 1-20 which have a different value each for each week and want to be
able to choose any range (ex. week 5 thou 12.) I want to be able to add the
total of 5-12 on the hidden sheetand output the total in the main sheet. I
currently have an imput for the start week (5) and end week (12) already; I
just need to be to be able to add only week 5-12 for a total.

Adding a range
 

It would have helped if you told us where the data is located and how it's
setup.

So, I'll have to guess where the data might be located!!!!!!!!!

Sheet2 B2:B21 = values to sum

Main sheet:

A2 = 5
B2 = 12

=SUM(INDEX(Sheet2!B2:B21,A2):INDEX(Sheet2!B2:B21,B 2))

--
Biff
Microsoft Excel MVP


"Josh" wrote in message
...
I have one sheet in Excel 2003 that is the main sheet and a hidden sheet
with
weeks 1-20 which have a different value each for each week and want to be
able to choose any range (ex. week 5 thou 12.) I want to be able to add
the
total of 5-12 on the hidden sheetand output the total in the main sheet. I
currently have an imput for the start week (5) and end week (12) already;
I
just need to be to be able to add only week 5-12 for a total.