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

===========