Re: Running 'Tally' Across Multiple Pages

[phillips yourisp com au]

Watch out for curcular references. If you put that function in cell C6 on
the sheet Total or First than you have a curcular reference and if it does
not trigger an error then it will give you exactly twice what you expect.

> I am trying to put Jody's 3d references to practical application, but
> I'm having a problem. I have built a workbook with a sheet called First
> and a sheet called Total and put 4 sheets in between them. The function
> - '=sum(First:Total!C6)' - returns a value exactly double of what is
> expected. The total should be '40' (cell C6 contains the value '10'
> across 4 sheets), not the '80' that is produced.
>
> Any help greatly appreciated...
>
> Chris G.
>
> On Fri, 2004-03-26 at 09:54, Chris Gray wrote:
>
> > I think my client will happily acquiesce to having the totals on the
> > last page. I will post my results here shortly...
> > Chris
> > On Fri, 2004-03-26 at 09:16, Jody Goldberg wrote:
> >
> > > On Fri, Mar 26, 2004 at 06:45:00PM +1000, frank brierley wrote:
> > > > So sheet names can be treated in a similar fashion to cell ranges,
> > nice.
> > > > 3d reference you say?  Will have to investigate this one.
> > > >
> > > > This would add the values of all the cells in the range from all
> > the sheets in the range, yes?
> > > yes.
> > >
> > > > What if you wanted a total for each sheet?
> > > Displayed on the first page ? hmm.  Dunno if it's possible.
> > > It would be nice to think we could something like
> > >
> > >     transpose(firstsheet:lastsheet:A1)
> > >
> > > but I don't see that working anytime soon
> > > _______________________________________________
> > > gnumeric-list mailing list
> > > gnumeric-list gnome org
> > > http://mail.gnome.org/mailman/listinfo/gnumeric-list