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,