View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default countif or sumproduct?

try this
=SUMPRODUCT((C2:C2000={"h","m","y","u"})*1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"arch0072" wrote in message
...
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?