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

FAQ

Thread Tools

Display Modes

02-26-2017, 01:33 AM

paulkaye

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

Office 2007

Advanced Beginner

Join Date: Nov 2011

Posts: 84

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

(Row 8 is used here just as an example)

I'd like to have a formula in cell D8 that sums the values in cells x8-y8, where x and y (the columns) can be defined by typing the column values in one or more other cells. For example, I'd type "F" in cell D1, and "M" in cell D2, and cell D8 would responsively display the sum of cells F8-M8.

Is this possible?

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