range names

P

Pedro

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
 
P

Pringles.

i dont' believe you can do what you are requesting w/o a macro (or even
with), but if you are wanting BOTH sums in the same cell, simplly input

=SUM(abc)&" "&D1

that should show both totals in the same cell, separated by a space.
 
P

Pedro

Sorry but i can't write what i want to sum but it's already written in
another cell like E1 = abc or def
 
Top