Passing parameters Cel Ref) to Sum function
 

I want to pass parameters Cel Ref) to Sum function. Any help?
Thanks in advance

Passing parameters Cel Ref) to Sum function
 

Does this mean you want to use VBA code to create a formula?

Passing parameters Cel Ref) to Sum function
 

Dear Dave O
Thanks for initiative to help me.
No I don't want VBA code. I want to capture cell reference (e.g. D12) and
wanna pass it second parameter (sum upto this ref) to
=SUM(D5:SecondParameter).


"Dave O" wrote:

Does this mean you want to use VBA code to create a formula?

Passing parameters Cel Ref) to Sum function
 

You may be able to use the OFFSET function. Or, if you assign a named
range to D12 you can use the formula =sum(D5:R) where R is the named
range.

Passing parameters Cel Ref) to Sum function
 

Dear Dave O
Thanks a lot for your help. The function OFFSET worked as per my
requirements. Thanks again, Take care
Bye
Shamshad Butt - Islamabad (Pakistan)

"Dave O" wrote:

You may be able to use the OFFSET function. Or, if you assign a named
range to D12 you can use the formula =sum(D5:R) where R is the named
range.