Thread: range name
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

H
use
=SUM(INDIRECT(C1))

--
Regards
Frank Kabel
Frankfurt, Germany

"Pedro" schrieb im Newsbeitrag
...
Hi everyone
Cells a1=1;a2=5;A3=3 I've name this cell as abc
Cells b1=2;b2=7;B3=4 I've name this cell as def
What i want is to input in cell c1 "abc" or "def" so i can have the

result
that i want, for example the sum of abc i input abc or the sum of def

if i
input def on that cell. Can i do it? Can you help me please?
Tks in advance
Pedro