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

You probably figured it out but if not you could put a If statement formula
in C1 depending on how many range names you have.
=IF(D1="abc",SUM(abc),IF(D1="def",SUM(def),0))

"Pedro" wrote:

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

try

=sum(indirect(d1))

no doublequotes in d1

whatever name range you type in d1 that sum will be there;.

Bricktop wrote in message
...
You probably figured it out but if not you could put a If statement
formula
in C1 depending on how many range names you have.
=IF(D1="abc",SUM(abc),IF(D1="def",SUM(def),0))

"Pedro" wrote:

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