View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default countif or sumproduct?

Try this:

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

I've assumed your data is in column D. You can use wildcards with
COUNTIF.

Hope this helps.

Pete

On Sep 3, 1:44*pm, 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?