Don't know what you got earlier, but it looks like this to me:
=IF(A1="-----",1,If(A1="--X--",0.5,0)) + etc for B1, C1...
You can only nest 7 if statements at once, so if you have more than 7 symbols, you will need to break it up
E.g.
=If (A1="-----",1,0)+if(A1="--X--",0.5,0)+...
Darcy --
Given the possible reading of your first post, the propsal Juan made allows for an extended set of numeric operations.
The current post is more specific and Tom has proposed a practical solution, which is however bounded by the number of symbols that you might have (embedding the danger of a long chain of IFs).
What follows is a different proposal.
Make a 2-column list of your symbols and the values associated with them in a worksheet named Admin, say, in columns B and C from row 2 on.
Lets say that B2:C4 houses the following symbols with their associated values, which can be expanded at will (Note: I use _ insted of -, because the former is easier to enter in a cell.).
{"_____",1;
"__X__",0.5;
"____X",2}
Select the cells with symbols in the first column and name the selection SYMS via the Name Box on the Formula Bar.
Select all cells of this 2-column list and name the selection ALIST via the Name Box on the Formula Bar.
How To Use All This?
In a different worksheet in A1:A4 enter one by one:
{"_____";
"__X__";
"__X__";
"_____"}
To sum A1:A4, you have to array-enter the following formula in some cell:
=SUM(N(OFFSET(ALIST,MATCH(A1:A4,SYMS,0)-1,1,1,1)))
In order to array-enter a formula, you need to hit control+shift+enter at the same time, not just enter.
Another example. In A1:E1 enter the following symbols:
{"_____","_____","__X__","__X__","____X"}
In some cell again array-enter:
=SUM(N(OFFSET(ALIST,MATCH(A1:E1,SYMS,0)-1,1,1,1)))
Enjoy.
Aladin
===========