EXCEL COUNTIF function

  Newuser3477 19:42 28 Feb 10
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 10

Try

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

  Newuser3477 22:20 28 Feb 10

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

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac