assign numeric value to letters and sum with other numbers

G

Galadad

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?
 
L

Lars-Åke Aspelin

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?
Click to expand...


Could you give an example of input and expected output.

Lars-Åke
 
G

Galadad

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.
 

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

sum letters with values and numbers 2
Find the maximum value in a row or column with text and numbers 2
Remove/Ignore Letters when Summing cells in a column. 3
ASSIGN NUMERICAL VALUES FOR LETTERS in EXCEL 2003 4
Sorting data of various length's, numbers, letters and dash's 4
Count the letters in the cells and sum in another cell 1
frequency function and letters [HOW?] 2
How do I assign a numeric value to a letter 1

Top