View Single Post
  #3   Report Post  
Lee
 
Posts: n/a
Default

If your data range is A1:A5 then:

=(COUNTIF(A1:A5,"/")*50)+(COUNTIF(A1:A5,"x")*100)

-----Original Message-----
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.
.