Locking A Cell Reference Regardless

BobBridges · #2 05-13-2014, 12:51 PM

I think the OFFSET function will do it for you. Yep, that's what you want. Try this:

Code:

=SUM(OFFSET(B3,0,1):OFFSET(B3,0,4))

The OFFSET function starts with a given cell (B3, in this case, which is the very cell the function is in), then adds a certain number of rows and columns to it. I specified 0 rows and between 1 and 4 columns.

You can just as easily specify a different starting cell and then correspondingly different row and column offsets; this just seemed intuitively obvious to me.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Keeping an absolute reference in a cell	bremen22	Excel	7	01-16-2014 11:06 AM
How to reference a cell value	Jmoney2290	Excel	1	11-06-2013 09:39 PM
Reference number and cross reference for equation numbers to match the thesis format	wmac	Word	1	05-14-2013 08:54 PM
locking out word	joe	Word	0	11-19-2009 02:09 AM
How do I reference a merged cell in a multi column & row table in MS Word ('03')?	jihanemo	Word Tables	0	03-18-2009 08:33 AM