Text formating in formula
=SUM(INDIRECT(SUBSTITUTE(A1,"/","_")))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"lasca" wrote in message
...
Hi,
I have the following problem:
In cell A1 I have a value of BP/SA, in cell B1 I want the sum of a named
range based on the value in cell A1 ie, "bp_sa", my Formula is thus
"=sum(bp_sa)".
I need to do a formula that will link the value from A1 and come up with
this, =sum(substitute(A1,"/","_"), The result is =sum("BP_SA") INSTEAD OF
=SUM(BP_SA). How do i get rid of the quotes around the returned value of
bp_sa.
Thx
|