I am having trouble with an formula. I want to add cells from many sheets. The formula I have been trying is.... =Sum('First'!E6:'Last'!E6). I want it so when I add worksheets between my named first and last sheets I don't have to update the formula on the totals page.
Bookmarks