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]
