Offsetting ranges in a formula...
Author Message
Offsetting ranges in a formula...

Hello,

I've got 2 named ranges in my spreadsheet, Cab1 and Cab2, and both of these
ranges are actually just one cell each, so I've basically just named 2
cells.  Now, I want to be able to sum everything in BETWEEN Cab1 and Cab2
and not actually include Cab1 and Cab2.  In other words, I want to
Sum(Cab1+1:Cab2-1).  How can this be done inside a formula?  Any ideas?

Thanks for any help!
Lee

Sat, 13 Aug 2005 02:27:16 GMT
Offsetting ranges in a formula...
One way:

=SUM(Cab1:Cab2)-Cab1-Cab2

Quote:
> Hello,

> I've got 2 named ranges in my spreadsheet, Cab1 and Cab2, and both of
these
> ranges are actually just one cell each, so I've basically just named 2
> cells.  Now, I want to be able to sum everything in BETWEEN Cab1 and Cab2
> and not actually include Cab1 and Cab2.  In other words, I want to
> Sum(Cab1+1:Cab2-1).  How can this be done inside a formula?  Any ideas?

> Thanks for any help!
> Lee

Sat, 13 Aug 2005 02:56:51 GMT
Offsetting ranges in a formula...
This should work:

=SUM(Cab1:Cab2) - SUM(Cab1,Cab2)

Quote:
>-----Original Message-----
>Hello,

>I've got 2 named ranges in my spreadsheet, Cab1 and Cab2,
and both of these
>ranges are actually just one cell each, so I've basically
just named 2
>cells.  Now, I want to be able to sum everything in

BETWEEN Cab1 and Cab2
Quote:
>and not actually include Cab1 and Cab2.  In other words,
I want to
>Sum(Cab1+1:Cab2-1).  How can this be done inside a

formula?  Any ideas?
Quote:

>Thanks for any help!
>Lee

>.

Sat, 13 Aug 2005 03:00:19 GMT

 Page 1 of 1 [ 3 post ]

Relevant Pages