i need to know how to total letter on a cell instead of numbers
 

i have a cell that is only consist of a Y and a C and i wanted to know how do
you know the totals of Y and totals of C

i need to know how to total letter on a cell instead of numbers
 

Do you mean you want to count the occurences of Y and the occurences of
C? It will help if you post a sample of your data, and your desired
outcome based on that sample.

i need to know how to total letter on a cell instead of numbers
 

to count Y =countif(A:A,"Y")

to count "C" =countif(A:A,"C")

"mei" wrote:

i have a cell that is only consist of a Y and a C and i wanted to know how do
you know the totals of Y and totals of C