countif or sumproduct?

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

 

[Don Guillett]

try this
=SUMPRODUCT((C2:C2000={"h","m","y","u"})*1)

 

[Mike H]

Maybe

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

or for the string beginning with hmyu

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

Mike

 

[Pete_UK]

Try this:

=COUNTIF(D,"*hmyu*")

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

Hope this helps.

Pete

 

[Don Guillett]

Tested?

 

[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

 

[Don Guillett]

Depends on how you read this--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Mike H]

If the OP is polite enough to respond then we will have our clarification