Are you able to give a letter a number value

B

Bryon

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 10
 
B

Bob Phillips

maybe something along the lines of

=SUM(IF(ISNUMBER(MATCH(A1:A10,{"X","A","B"},0)),LOOKUP(A1:A10,{"A","B","X";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)
 
D

David Biddulph

Bryon said:
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 10
Click to expand...

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.
 
Top