Countifs Formula including blanks

Desertbird ✭✭
edited 10/25/22 in Formulas and Functions

Hello, need some help with this formula. I have two columns one with a name, the other with a "yes"/"no" prompt. However some are left unfilled. I need to determine the number of names that are left blank in the prompt. When I tried =countif(col:col, "") it ends up counting the lower rows with nothing on them (hidden columns do have info on them, but I just need to count the ones with the first column filled out). It will likely need a countifs formula so it does not count the blank rows at the bottom of the sheet, but I am having trouble finding the right way to put it.

Edit: Figured it out on my own, thanks


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!