Counting cells containing text
Posted by Robin on January 08, 2001 4:21 AM
I have been asked if there is any way to count the number of cells that fall under a certain category.
This data appears in the same column in a worksheet. How can I get Excel to count the number of entries under the "male" and "female" categories?
Also, the number of names under each section changes every month and the number of blank cells may well alter as well. Thanks, Robin