Assigning a number value to a letter?

O

Orphan86

I am trying to see how I can assign a number value (10) to a letter (X) that
is typed into a cell. Everytime I type (X) I want it to represent the number
(10) in any formulas that I want to use it in. So, if a type (X) in seven
cells it should add up to 70. Can I do this?
 
B

Bob Phillips

=SUM(IF(A2:A20="X",10))

as an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
J

Jay

I am trying to see how I can assign a number value (10) to a letter
(X) that is typed into a cell. Everytime I type (X) I want it to
represent the number (10) in any formulas that I want to use it in.
So, if a type (X) in seven cells it should add up to 70. ...
Click to expand...

One way is illustrated by the example in the CSV file below.

---------- cut here ----------
X,G,"=10*COUNTIF(A1:B6,""X"")"
G,H,
H,X,
X,V,
V,X,
X,G,
 
G

Gary's Student

Amother approach is to put 10 in a cell, say A1, then pulldown Insert > Name >

enter X and touch Add.

From that point on you can use X in place of 10 in formulae. For example
you can put =37*X in a cell to get 370.

In your case you can put =X in a column to get your sum.
 
Top