countif or sumproduct?

A

arch0072

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?
 
M

Mike H

Maybe

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

or for the string beginning with hmyu

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

Mike
 
P

Pete_UK

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
 
M

Mike H

Yes, tested OK. I may have misunderstood the OP requirements but it does what
it was intended to do. i.e count the instances of hmyu either within or at
the start of any string in any cell in A:A

your issue being?

Mike
 
Top