=COUNTIF(A1:B500,"x")*100+COUNTIF(A1:B500,"/")*50
HTH. Best wishes Harald
"cfitz" skrev i melding
...
basically what i'm trying to do is this. i am using a spread sheet where
the
only things i put in the cells is "x" or "/", x will equal 100 and / will
equal 50. what i want to do is on the last cell is make it where it will
add
the numbers by the x's and /'s and then give me the total in number
format.
|