Thread
:
countif or sumproduct?
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
countif or sumproduct?
Depends on how you read this
one of the following letters
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Mike H" wrote in message
...
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" wrote:
Tested?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Mike H" wrote in message
...
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett