Entering a column value in a cell, to be used as part of a reference in a formula in another cell

		Microsoft Office Forums > Microsoft Excel > Excel
Entering a column value in a cell, to be used as part of a reference in a formula in another cell

02-26-2017, 04:01 AM

xor

Windows 10 Entering a column value in a cell, to be used as part of a reference in a formula in another cell

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

=sum(indirect($d$1&row(8:8)&":"&$d$2&row(8:8)))

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula for reference last non empty cell in row	npn321	Excel	10	02-22-2017 11:42 PM
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
Entering a number in a cell causes it to fill with the color of a nearby cell	Bill Martz	Excel	1	04-23-2015 07:57 PM
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?	bharathkumarst	Excel	7	10-13-2014 10:25 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:16 PM.