Use Column Reference in formula

[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

 

[Norman Harker]

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.

 

[Microsoft Newsgroups]

Thank you very much - worked like a charm!

 

[Norman Harker]

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.