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

WPA2 hack: How secure is your Wi-Fi?

HP’s new Surface Pro rival is designed specifically for Adobe-using designers and artists

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?