countif or sumproduct?

  • Thread starter Thread starter arch0072
  • Start date Start date
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?
 
Maybe

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

or for the string beginning with hmyu

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

Mike
 
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
 
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
 
Depends on how you read this--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
 
Back
Top