On Sun, 2004-01-25 at 12:03, Jean Bréfort wrote:
> The correct formula here is =SUM('Sheet 1'!A1:!A5). The documentation is
> wrong on that point.
a small typo. It should be =SUM('Sheet 1'!A1:A5)
>
> > 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?
>
> This is how database functions work. I don't think you can avoid them.
> It works the same in OpenCalc or Excel.
but we probably would all agree that we should have some more useful
database functions where we can avoid that table. Once we have iterators
we possibly should look at adding some.
Andreas
--
Prof. Dr. Andreas J. Guelzow
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta
Attachment:
signature.asc
Description: This is a digitally signed message part