Re: Running 'Tally' Across Multiple Pages

[frank brierley <frank_n_brierley yahoo com au>]

Chris,

You can find sums, totals, etc from other worksheets fairly easily by
adding the sheet name to the cell reference.  So for the value of a sum
of cells on Sheet2 to be displayed in a cell on Sheet1, you might enter
the formula...

=SUM(Sheet2!C2:C4)

in a cell on Sheet 1 (it is easier to select the cell/s as a range with
the mouse as Gnumeric automatically puts the "Sheet2!" bit in)

But the problem you are describing seems to be related to taking totals
from sheets that don't exist yet.  Does your client need to be able to
add a new sheet when a new project begins and have the totals
automagically appear?  If so, you might look at the INDIRECT function.

The INDIRECT function takes plain text and tries to return a cell (or
range) address for another function to use.  If cell B1 on Sheet1 were
to contain a project name (and there was a sheet with an identical name)
a formula in cell B2 on Sheet1 might contain...

=SUM(INDIRECT(B1&"!C2:C4))

The "TEXT" given to the INDIRECT function is "Project_Name!C2:C4".  This
would return the sum of values of the cells C2, C3, and C4 from the
sheet labelled with the project name

Your client could create a new sheet and rename it to the project name,
then enter the project name at the top of the summary column and have
Gnumeric start looking directly into the newly created sheet.

Frank

On Fri, 2004-03-26 at 05:47, Chris Gray wrote:
> I tried to Google this and search through this lists archives, but I am
> not even sure how to phrase my question properly...
>
> I am trying to build a Gnumeric file for a client where the first page
> in the workbook would contain running totals (just basic SUM functions)
> of the data from each subsequent page. The pages after the first - the
> 'Totals Page' - would be 'Project Pages'. 
>
> I am only looking to track a handful of figures for each project:
> Rental, Deposits, Security Fees, etc. I just need the 'Totals Page' to
> be a quick 'at a glance' summary and I need for my client to be able to
> add new project pages daily without 'breaking' the formulas.
>
> I vaguely remember something about vertical look-ups from an Excel class
> I took, but I don't recall being able to add new pages 'at will' without
> breaking the formulas.
>
> Any help GREATLY appreciated, thanks!
>
> Chris G.
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list