Thread
:
countif or sumproduct?
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
countif or sumproduct?
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