[mso] Re: Syntax Problem with SUM and INDIRECT functions

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).
http://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
*************************************************************

Other related posts: