Countifs Formula including blanks

Desertbird

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

Andrée Starå

Hi @Desertbird

I hope you're well and safe!

Excellent! Glad you got it working!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!