Re: Summing range of cells on another Tab

From: David Stanaway <david stanaway net>
To: Steve <bassix gmail com>
Cc: gnumeric-list <gnumeric-list gnome org>
Subject: Re: Summing range of cells on another Tab
Date: Fri, 07 Oct 2005 09:26:40 -0500

On Fri, 2005-10-07 at 10:12 -0400, Steve wrote:

Hi,

Can someone tell me what the gnumeric equivalent is for the following
excel command?

=SUM(races!C14:races!U14)



I think you can ommit the second sheet reference. I don't thing a range
spanning multiple sheets is very well defined, well at least I can't
imagine it would be.

=SUM(races!C14:U14)


You can see this pretty easily just by entering =sum(  then clicking
onto the other sheet and dragging the selection, it should write the
correct range specification into the formula.

References:
- Summing range of cells on another Tab
  - From: Steve

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