Count range of cells whether they are blank or have text
I am trying to count a few things in this sheet to track % of the Cabin completion. I want the total # of cells in a row that are either blank OR have text in them so that I know when all the cells in that row have been completed. I have tried multiple COUNTIF scenarios and its not working.
completed.
Best Answer
-
Hi @JennS - I have an idea! Let me know if this helps!
=COUNTIF({RANGE}, OR(@cell = "", @cell <> ""))
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
Answers
-
Hi @JennS - I have an idea! Let me know if this helps!
=COUNTIF({RANGE}, OR(@cell = "", @cell <> ""))
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
-
@Amber Eakin It worked! Thank you so much for your quick help!
-
how about if i want to count the "Blank" per month
=COUNTIFS({Battery CE Leads Range 1}, "Unqualified", {Battery CE Leads Range 2}, OR(@cell = "", {Battery CE Leads Range 3}, AND(IFERROR(MONTH(@cell), 0), Apr$1, IFERROR(YEAR(@cell), 0), =2023)))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!