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?
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?
Try
=SUM(A1:INDEX(A:A,LOOKUP(2^1023,A:A,ROW(A:A))-3))
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
Last edited by drgkt; 09-30-2017 at 06:04 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks