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.


Best Answer

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭
    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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!