# OFFSETTING a reference range to exclude 3 bottom rows

1. ## OFFSETTING a reference range to exclude 3 bottom rows

Hi
How do I define a growing by row insertion range to exclude 3 bottom rows?
Is there a way to do it with the OFFSET formula?

2. ## Re: OFFSETTING a reference range to exclude 3 bottom rows

Try

=SUM(A1:INDEX(A:A,LOOKUP(2^1023,A:A,ROW(A:A))-3))

3. ## Re: OFFSETTING a reference range to exclude 3 bottom rows

That might work with SUM, but what if I wanted to use for example INDEX of the A1:Z13 and I want to disregard data on the last 3 rows?

Edit: A1:Z13

4. ## Re: OFFSETTING a reference range to exclude 3 bottom rows

Originally Posted by drgkt
That might work with SUM...
What do you mean by "might"? Have you tried the suggested solution? You asked for a sum formula in your OP, didn't you?

Originally Posted by drgkt
... what if I wanted to use for example INDEX of the A1:Z13 and I want to disregard data on the last 3 rows?
What exactly are you trying to achieve with "INDEX of the A1:Z13"?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1