Thanks a lot. Much obliged. > Date: Wed, 4 Jun 2008 15:09:16 +0100 > To: [email protected] > From: [EMAIL PROTECTED] > Subject: Re: [users] totals in calc > > At 13:55 04/06/2008 +0200, Joe Grech wrote: > >Hi, my problem this time is I have about 12 sheets in calc one for > >each month. When the month is over a total is displayed. What I > >want is how can I make it add the respective totals of the 12 sheets > >at the end of the year to obtain a global total. > > You mean you have multiple sheets in the same spreadsheet? And that > your problem is just that the items you want totalled are on separate sheets? > > o Select the destination cell. > o Press the sigma symbol in the Input line - or just enter "=SUM(". > o Click the sheet tab to display the sheet containing your first > monthly total. > o Click the monthly total. > o Press ";" (semicolon). > o Repeat the last three steps for the other monthly totals (except > for no semicolon in the last case). > o Press Enter or the green tick in the Input line. > > You will see from the formula constructed how sheet names can be > prefixed to cell names to enable you to do what you need. > > Another way might be to assemble the values in one place and on one > sheet - using =sheet.cell - and then to sum the values there directly. > > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] >
_________________________________________________________________ Connect to the next generation of MSN Messenger http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
