how do i represent numbers with letters
 

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.

=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.

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

Or in one fell swoop

=SUMPRODUCT(COUNTIF(A1:B500,{"x","/"}),{100,50})


--

Regards,

Peo Sjoblom



"Harald Staff" wrote in message
...
=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.

Hey, this is the "newusers" newsgroup <bg

Best wishes Harald

"Peo Sjoblom" skrev i melding
...
Or in one fell swoop

=SUMPRODUCT(COUNTIF(A1:B500,{"x","/"}),{100,50})


--

Regards,

Peo Sjoblom



"Harald Staff" wrote in message
...
=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.