Excel Count Functions
My bad, you are absolutely correct. I apologize for the error!
"David Biddulph" wrote:
Won't that double count if the cell contains both a and x?
--
David Biddulph
"Gary Mc" wrote in message
...
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?
|