Here is a tip on how to do this...

http://www.openofficetips.com/blog/archives/2005/08/summing_across.html

Dave

On 9/28/05, Paul <[EMAIL PROTECTED]> wrote:
>
> 1/ try the following formula:
> =<sheetname>.cellReference+<sheetname>.cellReference+ ...
>
> 2/ The mailing list is very active. The digest version is probably
> what you want. Unsubscribe from this one and subscribe to the digest
> (groups emails together to one large one that you receive about 5 per
> day) using this link :
> http://www.openoffice.org/mail_list.html
>
> /paul
>
> On 9/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > Apparently I made a mistake in asking my question in the same message as
> > the subscribe request, so here it is again, plus a second question.
> >
> > Is there a way to sum the contents of the same cell on multiple sheets?
> I
> > want to sum the N1 cell on, perhaps, thirty different sheets.
> >
> > How do I stem the flood of mail I now receive on many subjects which do
> > not at this time interest me? I am willing to download an index every so
> > often.
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>


--
My OpenOffice Calc Website
http://www.openofficetips.com

Reply via email to