Formula inquiry: Tally the count of empty cells in a column


Is there a formula that simply tallies the count of empty cells in a column? I use the COUNTIF all the time to tally the count of cells with certain information and that's easy, however the same function doesn't seem to work in capturing the count of empty cells. I have scoured Google and Smartsheet the last few days and tried COUNTIF, IFBLANK, NOT formulas, and can't seem to find one that will work. It seems like something that should be quite simple. Any insight would be greatly appreciated.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!