=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" wrote in message
...
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?
|