Here’s a few neat ways to count Text, Blanks and Non-Blank cells using the Countif() function.
Count All Non-Blanks
Count All Text
Count All Blanks
You can download a sample of the above Countif_Quicktips
Learn More about the Countif() function
Leave a Reply
|What is the coolest Excel trick you have learned this year?||Sporadic Totals in Excel [video]|