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.