Thread: [Solved] Entering a column value in a cell, to be used as part of a reference in a formula in another cell
View Single Post
 
Old 02-26-2017, 01:33 AM
paulkaye paulkaye is offline Windows 7 64bit Office 2007
Advanced Beginner
  
Join Date: Nov 2011
Posts: 84
paulkaye is on a distinguished road
Default 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?
Reply With Quote