Assigning a number value to a letter?

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?

=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)


"Orphan86" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

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,

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.
--
Gary's Student


"Jay" wrote:

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