View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Mc Gary Mc is offline
external usenet poster
 
Posts: 17
Default Excel Count Functions

I'm sure there are other and probably better solutions but this will work
=SUM(COUNTIF(B2:E2,"*a*"),COUNTIF(B2:E2,"*x*"))
Hope this is helpful
GMc

"Gasbag" wrote:

I am trying to count the number of cells in a row that contain one or more of
three letters?