Thanks Dave, and everyone for your suggestions with my problem. I finally did indeed use Hutch's suggestion and it's working fine, and your comments on the benefits of using this technique are good ones. Thanks again Larry ,,,,,,, Ô¿Ô¬ In a message dated 7/14/2009 11:31:03 P.M. Eastern Daylight Time, smartware@xxxxxxxxxxxxxxx writes: I think that Indirect () does indeed have a problem with a 3D reference. E.g. =SUM(INDIRECT("'Sheet 1'!a12:c14")) works fine but =SUM(INDIRECT("'Sheet 1:Sheet 2'!a12:c14")) fails. So this approach is not going to work. FWIW I do the same thing as Hutch is suggesting - i.e. dummy first and last sheets. This has a couple of advantages too: - It doesn't matter what the inner sheets are called, so they can have meaningful names, such as the persons' names if the sheets are one per person. - You don't need to maintain a separate "number of sheets" cell, that could get out of step. Regards, Dave S **************Snoop, Lil Wayne, Lady GaGa -- land the tix you need for this summer's biggest tours. Tourtracker.com (http://www.tourtracker.com/?ncid=emlcntusmusi00000007) ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to share files with the group, you must join our Yahoo sister group. This group will not allow for posting of emails, but will allow you to join and share problem files, templates, etc.: http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE SHARING ONLY. If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************