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

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

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

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
.