Hello there,
In the attached file, you will find numbers in cells A1 to BN1. Then BO1 is the number of cells which contain numbers less than 2. ie =countif(A1:BN1,"<2") The number which should show up is 9, but excel is giving 11.
Can someone advise me on whats wrong?
Bookmarks