Use Column Reference in formula

  • Thread starter Thread starter Microsoft Newsgroups
  • Start date Start date
M

Microsoft Newsgroups

How can I use the column letter in a formula?

=sum(c10:ax10)

I want the "ax10" to be dynamic based on a cell value. For example, it the
cell value is 14, I want to use the 14th column (N) in stead of "AX"

I know how to do this in VBA, but not sure how using a worksheet function.

Any help is appreciated.

Thanks,

Tom
 
Hi Tom!

Try:
=SUM(C10:INDIRECT(ADDRESS(10,A1)))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Tom!

Thanks for thanks is always appreciated and confirms to Google
searchers that it works.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top