Using COUNTIF to find the number of Blank Spaces

2»

Comments

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭

    Well Done!

    Yes, it was this reason that I asked if you were selecting the range of cells or the whole column.  There is always a set of extra blank rows at the end of a smartsheet which this formula was including in the count, even though they weren't active rows.

    But you figured that out too!

    Great :)

    Phew!

    I look forward to the next one! :)

    Debbie