View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default countif or sumproduct?

Maybe

=COUNTIF(A:A,"*hmyu*")

or for the string beginning with hmyu

=COUNTIF(A:A,"hmyu*")

Mike

"arch0072" wrote:

i have a column with over 2000 alpha character rows that i'm trying to count.

I have a the one of the following letters hmyubsqzvtgxce in the rows of the
column.

I'm trying to count the total number of hmyu when listed in this column?