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?
|