| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
assign numeric value to letters and sum with other numbers
I apologize if I am duplicating an earlier question, but I can't find the
answer. How do I sum a row or column that has numbers and letters by giving the letters a numerical equivalent? -- WJG |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
assign numeric value to letters and sum with other numbers
On Mon, 11 Jan 2010 12:19:01 -0800, Galadad
wrote: I apologize if I am duplicating an earlier question, but I can't find the answer. How do I sum a row or column that has numbers and letters by giving the letters a numerical equivalent? Could you give an example of input and expected output. Lars-Åke |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
assign numeric value to letters and sum with other numbers
Just guessing he maybe =row() and =column()
-- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Galadad" wrote: I apologize if I am duplicating an earlier question, but I can't find the answer. How do I sum a row or column that has numbers and letters by giving the letters a numerical equivalent? -- WJG |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
assign numeric value to letters and sum with other numbers
This is a horrible question on my part. Sorry, I was trying to find my
original question which is 12 threads below entitled "sum letters with values and numbers". This explains the situation and gives a great answer. Thank you both for trying. -- WJG "Lars-Ã…ke Aspelin" wrote: On Mon, 11 Jan 2010 12:19:01 -0800, Galadad wrote: I apologize if I am duplicating an earlier question, but I can't find the answer. How do I sum a row or column that has numbers and letters by giving the letters a numerical equivalent? Could you give an example of input and expected output. Lars-Ã…ke . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: I want to assign numeric values to letters in a speradsheet | Excel Discussion (Misc queries) | |||
| How do I assign a numeric value to a letter | Excel Worksheet Functions | |||
| How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric? | Excel Worksheet Functions | |||
| How do I assign a numeric value to text? IE cell = yes then 1 | Excel Discussion (Misc queries) | |||
| How do I assign a numeric value to a text letter | Excel Discussion (Misc queries) | |||
Linear Mode
