S
Shamshad Butt
I want to pass parameters Cel Ref) to Sum function. Any help?
Thanks in advance
Thanks in advance
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave O
Does this mean you want to use VBA code to create a formula?
S
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).
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).
D
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.
range to D12 you can use the formula =sum(D5:R) where R is the named
range.
S
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)
Thanks a lot for your help. The function OFFSET worked as per my
requirements. Thanks again, Take care
Bye
Shamshad Butt - Islamabad (Pakistan)