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
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« What is the coolest Excel trick you have learned this year?||Sporadic Totals in Excel [video] »|