countif or sumproduct?
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
On Sep 3, 1:44*pm, 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?
|