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
Do you want to be awesome in Excel?
Here is a smart way to become awesome in Excel. Just signup for my Excel newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
Leave a Reply
|What is the coolest Excel trick you have learned this year?||Sporadic Totals in Excel [video]|