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.
Help Article Resources
Check out the Formula Handbook template!