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 themthanks peter
It works a treat thanks, why didn't i think of that solution
This thread is now locked and can not be replied to.
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 ?
© Copyright 2018 IDG UK. All Rights Reserved.