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
Introducing our Online Power BI Class:
Would you like to join me on a date with Power BI? In this comprehensive online class, learn all about Power BI so you can create beautiful, insightful & interactive reports. Join me and rest of the play mates for our first ever Power BI Play Date.Click here to know more and join us.
Leave a Reply
|What is the coolest Excel trick you have learned this year?||Sporadic Totals in Excel [video]|