View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nikki
 
Posts: n/a
Default 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