how to assign a value to the alphabet in order to add up letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to add up cells that have either a "a" in it or a "h" in it. I
would like to assign a value of 1 to "a" and 2 to "h"
 
One way

=SUMPRODUCT(COUNTIF(A1:A10,{"a";"h"}),{1;2})

with your a and h in A1:A10

Regards,

Peo Sjoblom
 
You must log in or register to reply here.

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

Assigning letter for numerical value 8
Scrabble Value calculation for Welsh words 0
How to type each letter of the alphabet automatically in a specific color in Word? 0
Solver - Assign values to Letters of the Alphabet 3
Solver - Assign values to the letters of the alphabet 2
Counting how many numbers and letters appear in a particular row 7
convert text to number 2
Giving letters a numerical value, then adding the total. 17

Back
Top