Re: Using dsum across sheets

[Mike Perry <mikepery fscked org>]

Thus spake Jean Br?fort (jean brefort ac-dijon fr):

> Le dim 25/01/2004 ?? 01:44, Mike Perry a ??crit :
> > Is it possible to use the DSUM function on values from two different
> > sheets? For example, I am trying to write something like:
> > 
> > =DSUM(Timetable!A1:Timetable!F45, Timetable!F, A1,A17)
> > 

> You have probably two mistakes in your formula. The first is that dsum
> needs 3 arguments and not more. You must provide your critria in a
> separate block as
> 	B
> 1	Job #
> 2	16
> Secondly, the second argument should be either the label of the column
> ("Time Delta") or the rank of the column in the database (this is what
> is in the doc, but I couldn't make it work).
> So your formula might be:
> =DSUM(Timetable!A1:F5;"Time Delta";B1:B2)

=dsum(Timetable!A1:F45,"Time Delta",A1:A2) works, but the manual then is
a bit misleading. In example 5.10 in
http://www.gnome.org/projects/gnumeric/doc/sect-data-types.html, they
say you are to do  =SUM('Sheet 1'!A1:'Sheet 1'!A5) when referencing a range
from another sheet..

Also, why is it that "Time Delta" doesn't have a sheet scope on it? What
if I happen to have a "Time Delta" field in the Jobtable (which I don't,
but this seems like it would produce ill-defined behavior then).

Also, do I really need to use a range for the third argument? I really
don't want to have to create 16+ (the actual number of Jobs is
unbounded) mini-tables with just a "Job #" and a number in it,
especially when I already number each job in the Jobtable sheet. Is
there a function or something I can do to avoid all these needless
mini-tables?

Example 5.7 of the manual (same page) says I am supposedly able to specify
combination of cells with commas, which is again misleading cause it
doesn't work in this case.

-- 
Mike Perry
Mad Computer Scientist
fscked.org evil labs