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.

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!