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

Author Message
barneyrubble
Newbie

Joined: 03 Mar 2008
Posts: 4

 Posted: Mon Mar 03, 2008 1:39 pm    Post subject: Open Office spreadsheet column total I have tried to get my spreadsheets to total but I just get the error code below and I don't understand what I need to do to correct the setup for the spreadsheet can any one help? 524 invalid references (instead of Err:524 cell contains #REF) Compiler: a column or row description name could not be resolved. Interpreter: in a formula, the column, row, or sheet that contains a referenced cell is missing.
PromptJock
Super User

Joined: 26 Jul 2006
Posts: 741

 Posted: Mon Mar 03, 2008 9:09 pm    Post subject: Well, if you enter the formula =sum(:) in the cell you want to total to appear in, you shouldn't have a problem. IOW, if you're totaling cells 1-300 in the "A" column, simply put the formula "=sum(a1:a300)" in any empty cell NOT in the range you're trying to sum together (i.e., put the formula in cell B1). Does this help or make any sense?_________________I'm making perfect sense - you're just not keeping up!
barneyrubble
Newbie

Joined: 03 Mar 2008
Posts: 4

 Posted: Mon Mar 03, 2008 11:32 pm    Post subject: Thank you I was trying to use the "M" automatic button after highlighting the column. Do you know how I set up this to work? the Auto Sum is ticked on the program so I don't know why this action gives the error message.
David
Super User

Joined: 24 Oct 2003
Posts: 5668

Posted: Tue Mar 04, 2008 6:43 am    Post subject:

 barneyrubble wrote: Thank you I was trying to use the "M" automatic button after highlighting the column.

By "M" you mean the summation symbol, Greek Sigma?

That works for me whether or not I precede using it by highlighting the column. The result is placed at the end of the selection, or sums those above if you are in a cell below the entries [not selected].

David.
barneyrubble
Newbie

Joined: 03 Mar 2008
Posts: 4

 Posted: Tue Mar 04, 2008 12:35 pm    Post subject: Yes that is what I try but on my computer I just get the error message?? I have previously used xp professional excel and had no problems just cant get open office to do the same thing. It has to be a set up problem I have tried looking on help section, but cant see this problem explained and don't know what else to try!!
jrkrideau
Super User

Joined: 08 Aug 2005
Posts: 6732

Posted: Tue Mar 04, 2008 1:45 pm    Post subject:

 barneyrubble wrote: Yes that is what I try but on my computer I just get the error message?? I have previously used xp professional excel and had no problems just cant get open office to do the same thing. It has to be a set up problem I have tried looking on help section, but cant see this problem explained and don't know what else to try!!

What OS and version of OOo are you using?

If it is a brand-new installation you might want to consider running a repair on OOo to see if that helps.
_________________
jrkrideau
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
barneyrubble
Newbie

Joined: 03 Mar 2008
Posts: 4

 Posted: Wed Mar 05, 2008 4:22 am    Post subject: Im using 2.2 on an applemac. How would I repair ?
jrkrideau
Super User

Joined: 08 Aug 2005
Posts: 6732

Posted: Wed Mar 05, 2008 9:42 am    Post subject:

 barneyrubble wrote: Im using 2.2 on an applemac. How would I repair ?

Beats me. I have been using XP for some time (sob ) you might have to uninstall and reinstall.
_________________
jrkrideau
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
 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