[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
pt
General User

Joined: 16 Dec 2005
Posts: 18

 Posted: Fri Dec 16, 2005 7:31 am    Post subject: unable to reference multiple sheets Having difficulty creating a formula the references multiple sheets. For example starting with a sheet called Summary which is sheet 2 of 29 and entering =SUM(Mar00.C5;Mar01.C5;Mar02.C5;Mar03.C5;Mar04.C5) and then hitting enter the following is returned =SUM(Mar00.C5;Mar01.C5;Mar02.C5;Mar03.C5,#REF!.C5) however entering =SUM(Mar00.C5;Mar01.C5;Mar02.C5;Mar03.C5) only returns the correct sum. Thank you
noranthon
Super User

Joined: 07 Jul 2005
Posts: 3318

 Posted: Fri Dec 16, 2005 9:54 pm    Post subject: unable to reference multiple sheets I successfully entered a formula summing the contents of cell C5 in 5 consecutive sheets. My formula was exactly the same as yours except, of course, for the sheet names. In case of some quirk involving your sheet names, I even made a document using the same names. You should check that the name Mar04 is correct - there may, for example, be a space which you can't see. I notice also that your post shows a comma after "Mar03.C5" instead of a semi-colon, as: Mar03.C5,#REF!.C5 but if I use a comma there I get "#NAME?". If I mispell the sheetname I get the result you mention (but no comma): =SUM(aim.C5;brw.C5;buy.C5;cuo.C5;#REF!.C5)
pt
General User

Joined: 16 Dec 2005
Posts: 18

 Posted: Sat Dec 17, 2005 8:24 am    Post subject: reference multiple sheets You are absolutely correct, I had some spaces in my sheet names. Thank you for the help.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum