countif or sumproduct?
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?
|