range names
 

Hi everyone
Suppose this example:
a1;a2;A3 equals 5, 7, 9
b1;b2;b3 equals 2, 3,8
Name range for first range abc
Name range for second range def
There's a formula on cell c1 : Sum(abc)
What i would like is : on cell d1, i input abc or def or another range name
and on cell c1, without any macro but a formula, it sums what i input on cell
d1, abc or def.
Can you help me please?
Tks in advance
Pedro

Hi
see your other post:
=SUM(INDIRECT(D1))

--
Regards
Frank Kabel
Frankfurt, Germany

"Pedro" schrieb im Newsbeitrag
...
Hi everyone
Suppose this example:
a1;a2;A3 equals 5, 7, 9
b1;b2;b3 equals 2, 3,8
Name range for first range abc
Name range for second range def
There's a formula on cell c1 : Sum(abc)
What i would like is : on cell d1, i input abc or def or another
range name
and on cell c1, without any macro but a formula, it sums what i input
on cell
d1, abc or def.
Can you help me please?
Tks in advance
Pedro