Here are a couple options:

You could leave the x's and use COUNTIF and/or SUMIF functions:
Example:
=COUNTIF(A1:A100,"x")
will count the number of cells in A1:A100 that contain an x.

Alternatively, you could.....
-Select the range of cells
-EditReplace
\Find what: x
\Replace with: 1
\Click the [Replace All] button

Does either of those help?

**************
Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=486837