Would you care to restate your question.

You're using mixed references,
Column A2 ? ? ?
Calculate C - but you're looking for a column reference? or a row reference
in Column C?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Bruce" wrote in message
...
I want to sum a dynamic range based on a value (myValue). The idea behind
this is as myValue changes so will the range summed. The formula will
first
get the column number of the start of the range, then add myValue and
return
this as the end column reference in the sum formula.

For example,

Say myValue is the value of 2 in cell B2.
To Sum(A2:C3) I want to calculate C.
So Column(A2) + B2 = 3.

How can I convert this 3 back to a column reference and insert into the
sum
formula?

Bruce