How to add up letters to equal a number value.

F

FrizB

I'm sure this is easy... I have two columns that contain different letters. I
want to create a cells that will add up all the like letters,(the letters
represent abbreviations for different payor sources) i.e. How many A's, how
many K's, etc. I've used SUMPRODUCT, but get a NAME?error. I guess I don't
know how to represent the letters as numbers. Please help, I'm going nuts!!!
 
J

Jacob Skaria

'number of k's in column A
=COUNTIF(A:A,"A")

'number of K's in column A
=COUNTIF(A:A,"K")

If 'a' or 'k' is within the cell then try
=COUNTIF(A:A,"*A*")


If this post helps click Yes
 

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

Formulas to display all 3 letter combinations in 8 letters 1
How doo I add letters or numbers to a whole column of part #s 1
Excel Add ^ to a row of cells containing letters 3
Text to Columns Letters and Numbers 5
Giving letters a numerical value, then adding the total. 17
Column chngd fm letters to numbers. What that & how do I go back? 1
How to change numbered columns to letters? 3
How do I change the column button to letters instead of numbers? 2

Top