| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add up letters to equal a number value.
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!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to add up letters to equal a number value.
'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 --------------- Jacob Skaria "FrizB" wrote: 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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to get a text/letters to equal to a percentage | Excel Worksheet Functions | |||
| enter a number if equal to another number | Excel Discussion (Misc queries) | |||
| first number in a column not equal to zero | New Users to Excel | |||
| how i write a number on a column A and see that number on letters. | Excel Worksheet Functions | |||
| I want a series of letters to equal a dollar amount? | Excel Discussion (Misc queries) | |||
Linear Mode
