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.