Newuser3477 19:42 28 Feb 2010

I want to count the number of cells in a row which contain either a nought or a one. I expected =COUNTIF(B33:AI33),"0,1")to work but it doesn't. Can anyone provide correct function, note some cells in the range have an X in them
thanks peter

  VoG II 19:52 28 Feb 2010



  Newuser3477 22:20 28 Feb 2010

It works a treat thanks, why didn't i think of that solution

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy S9 review

Wacom Cintiq Pro 24 and 32 review – hands-on

When is the next Apple event?

Qu’est-ce qu’Amazon Prime ?