I am trying to create a countif formula to give me a count at the top of my column of how many empty rows in a shelf I have. If certain spaces in the shelf are empty they are labeled in my column as "EMPTY". I have tried this formula: =COUNTIF([Study Number]1:[Study Number]636, = "empty") but am having no luck. Please help!


Best Answer

  • JCluff
    JCluff ✭✭✭✭
    Answer ✓


    When doing a COUNTIF formula you do not need to put the = sign in the criterion section. Also, unless your range needs to end at row 636 I would adjust the range to include the entire column. Try the formula below:

    =COUNTIF([Study Number]:[Study Number],"EMPTY")

    If you need it to end on row 636:

    =COUNTIF([Study Number]1:[Study Number]636,"EMPTY")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!