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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set cell value to emptry if three other columns are empty too 1
Macro that copies values from column A (from formula) to B (paste value) 1
Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1
Figuring out a lengthy formula. Probably quite simple... 3
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
Excel VBA 1
In a sales quote sheet - sum totals by license type 1
Excel Help to copy information from one row at a time to another sheet 1

Back
Top