EXCEL COUNTIF function

  Newuser3477 19:42 28 Feb 2010
Locked

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

Try

=COUNTIF(B33:IA33,0)+COUNTIF(B33:IA33,1)

  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

Galaxy Note 8 vs iPhone X

Aardman's new YouTube channel to share the work of independent animators

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017