how do i represent numbers with letters

C

cfitz

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

Harald Staff

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

Lee

If your data range is A1:A5 then:

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

Peo Sjoblom

Or in one fell swoop

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


--

Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
How can the font and size of (all) citation numbers be altered? 1
How do I use letters to represent numbers? 2
Combining AND and OR functions 1
A couple questions BEFORE using Office 365 0
How To Rapidly Copy Formulas? 0
Page numbering with Merged Document and IF statements 1
Finding a group of 'b' numbers that match close to a given target value. 0

Top