software

I am trying to give letters a number value so when sum a row or colume it
will reflect a number value even though there are letters..

Ex: X=5
A1 = X
A2 = X
A3 = SUM(A1:A2) A3 would reflect 10maybe something along the lines of

=SUM(IF(ISNUMBER(MATCH(A1:A10,{quot;Xquot;,quot;Aquot;,quot;Bquot;},0)),LO OKUP(A1:A10,{quot;Aquot;,quot;Bquot;,quot;Xquot;;5
,10,15})))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Bryonquot; gt; wrote in message
...
gt; I am trying to give letters a number value so when sum a row or colume it
gt; will reflect a number value even though there are letters..
gt;
gt; Ex: X=5
gt; A1 = X
gt; A2 = X
gt; A3 = SUM(A1:A2) A3 would reflect 10
gt;
quot;Bryonquot; gt; wrote in message
...
gt;I am trying to give letters a number value so when sum a row or colume it
gt; will reflect a number value even though there are letters..
gt;
gt; Ex: X=5
gt; A1 = X
gt; A2 = X
gt; A3 = SUM(A1:A2) A3 would reflect 10

Put your 5 in a convenient cell (D1, for example), and having selected that
cell use Insert/ Name/ Define, and call it X.
Then in A1 and A2 you can put =X as you suggest.
--
David Biddulph