software

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, quot;bp_saquot;, my Formula is thus
quot;=sum(bp_sa)quot;.

I need to do a formula that will link the value from A1 and come up with
this, =sum(substitute(A1,quot;/quot;,quot;_quot;), The result is =sum(quot;BP_SAquot;) INSTEAD OF
=SUM(BP_SA). How do i get rid of the quotes around the returned value of
bp_sa.

Thx=SUM(INDIRECT(SUBSTITUTE(A1,quot;/quot;,quot;_quot;)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;lascaquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I have the following problem:
gt;
gt; In cell A1 I have a value of BP/SA, in cell B1 I want the sum of a named
gt; range based on the value in cell A1 ie, quot;bp_saquot;, my Formula is thus
gt; quot;=sum(bp_sa)quot;.
gt;
gt; I need to do a formula that will link the value from A1 and come up with
gt; this, =sum(substitute(A1,quot;/quot;,quot;_quot;), The result is =sum(quot;BP_SAquot;) INSTEAD OF
gt; =SUM(BP_SA). How do i get rid of the quotes around the returned value of
gt; bp_sa.
gt;
gt; Thx
gt;

=SUM(INDIRECT(SUBSTITUTE(A1,quot;/quot;,quot;_quot;)))

HTH

quot;lascaquot; wrote:

gt; Hi,
gt;
gt; I have the following problem:
gt;
gt; In cell A1 I have a value of BP/SA, in cell B1 I want the sum of a named
gt; range based on the value in cell A1 ie, quot;bp_saquot;, my Formula is thus
gt; quot;=sum(bp_sa)quot;.
gt;
gt; I need to do a formula that will link the value from A1 and come up with
gt; this, =sum(substitute(A1,quot;/quot;,quot;_quot;), The result is =sum(quot;BP_SAquot;) INSTEAD OF
gt; =SUM(BP_SA). How do i get rid of the quotes around the returned value of
gt; bp_sa.
gt;
gt; Thx
gt;

Thx!!!!! It worked

quot;Toppersquot; wrote:

gt;
gt; =SUM(INDIRECT(SUBSTITUTE(A1,quot;/quot;,quot;_quot;)))
gt;
gt; HTH
gt;
gt; quot;lascaquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I have the following problem:
gt; gt;
gt; gt; In cell A1 I have a value of BP/SA, in cell B1 I want the sum of a named
gt; gt; range based on the value in cell A1 ie, quot;bp_saquot;, my Formula is thus
gt; gt; quot;=sum(bp_sa)quot;.
gt; gt;
gt; gt; I need to do a formula that will link the value from A1 and come up with
gt; gt; this, =sum(substitute(A1,quot;/quot;,quot;_quot;), The result is =sum(quot;BP_SAquot;) INSTEAD OF
gt; gt; =SUM(BP_SA). How do i get rid of the quotes around the returned value of
gt; gt; bp_sa.
gt; gt;
gt; gt; Thx
gt; gt;