Sorry, I forgot to mention that the formula needs to be confirmed with
CONTROL+SHIFT+ENTER.

In article ,
Domenic wrote:

Hi Sam,

That's probably because your formulas within your range of cells return
a "" (null string) when their particular condition evaluates to false.
In this case, we can tweak Aladin's formula...

=COLUMNS(C5:L5)-IF(COUNTIF(C5:L5,"x"),MATCH(2,1/(C5:L5="x")))

Hope this helps!