Active Column Ref in a Formula

  • Thread starter Thread starter Glynn Taylor
  • Start date Start date
G

Glynn Taylor

The formula in a cell sums accross a row from a fixed column to the column
containing the formula

How do I have a variable which represents the active column?

Thank you
 
If my formula is in x17 (say), I could use this formula in X17:

=Sum($a17:W17)

it'll sum from column A to the column to the left of the cell with the formula
(X17 in my example).
 
Back
Top