In most counting scenarios in Excel, COUNTBLANK reliably counts blank cells, and COUNTA reliably counts populated cells.
If Click To Do in Windows 11 couldn't highlight anything or has stopped working, check the Group Policy or Registry setting ...