View Single Post
  #9   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

Sam via OfficeKB.com wrote:
Hi Aladin,

Thank you for reply. The Formula returns the correct result for all Rows
where there is an "x" in one or more columns. Unfortunately, where there
are no "x"'s in the Row it should return a count of 10 but returns 0 (zero).

=IF(COUNTIF(C5:L5,"x"),COLUMNS(C5:L5)-MATCH(2,1/(C5:L5="x")),0)
which needs to be confirmed with+control+enter

Any further help much appreciated.

Thanks
Sam


I didn't notice you you wanted 10 for that. See the tweaked version in
Domenic's reply,