| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
|
#3
|
|||
|
|||
|
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. . |
|
#4
|
|||
|
|||
|
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. |
|
#5
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
| Excel column headings from numbers to letters | Excel Discussion (Misc queries) | |||
| Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
| How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
| Hor to write numbers in letters in spanish | Excel Worksheet Functions | |||
Linear Mode
