how do i represent numbers with letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...
format.
 
Or in one fell swoop

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


--

Regards,

Peo Sjoblom
 
Back
Top