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.