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  
 
 [ 3 post ] 

 Relevant Pages 

1. Offsetting ranges

2. range of offset

3. Offset from Range address

4. Range including offset

5. help on an offset problem where last cell in range changes

6. Type mismatch with offset and named range

7. copy range after offset

8. Range Name Offset...I Give Up

9. Countif(range,weekday(offset)<6)

10. Define end of Range using Offset?


 
Powered by phpBB® Forum Software © phpBB Group