Re: Running 'Tally' Across Multiple Pages



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


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]