Passing parameters Cel Ref) to Sum function

[Shamshad Butt]

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

[Dave O]

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

[Shamshad Butt]

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?
>
>

[Dave O]

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.

[Shamshad Butt]

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.
>
>