range name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
you already have received some answers to your question.
PLEASE don't multipost. If you have probelms with the offered solutions
please stay in the thread and post back in the original thread
 
Back
Top