To make "X" have the value of 1 in an Excel spreadsheet, you can follow these steps:

1. Select the cell where you want to enter the "X" value.
2. Type "1" instead of "X" in the cell.
3. Press Enter to save the value.

Alternatively, you can use a formula to automatically convert "X" to 1 in a separate column. Here's how:

1. Insert a new column next to the column with "X" values.
2. In the first cell of the new column, enter the formula
   Formula:

   "=IF(A1="X",1,0)" 

   (assuming the "X" values are in column A).
3. Press Enter to save the formula.
4. Copy the formula to the rest of the cells in the new column.
5. The new column will now show 1 for every "X" value in the original column, and 0 for every other value.

To total the new column automatically, you can use the SUM function. Here's how:

1. Select the cell where you want the total to appear.
2. Type
   Formula:

   "=SUM(B1:B10)" 

   (assuming the new column is B1:B10).
3. Press Enter to save the formula.
4. The cell will now show the total of all the 1's in the new column.