Counting in Excel
Posted by Laura Sapovits on March 12, 2001 7:08 AM
What formula do I use to count cells in b2:b15 that do not contain " " (a space). If I need to put characters, then "ll" (alpha/lower case L). Thanks!
Posted by Mark W. on March 12, 2001 7:30 AM
=COUNTIF(B2:B15,"<>* *")
Posted by Aladin Akyurek on March 12, 2001 7:37 AM
=COUNTIF(B2:B15,"<>"&CHAR(32))
This will skip cells with a space in them.
Aladin
Posted by Mark W. on March 12, 2001 7:50 AM
Aladin, this will only work if a B2:B15 contains
nothing but a single space. It won't work if one
of these cells contains a phrase with imbedded
spaces such as "To be or not to be".
Posted by Aladin Akyurek on March 12, 2001 8:51 AM
Hi, Mark.- That's right. But, I thought that was also what is wanted. BTW, I was posting from school just a few secs before a database class, so I didn't see your post with wild cards.
