If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled ...
In most counting scenarios in Excel, COUNTBLANK reliably counts blank cells, and COUNTA reliably counts populated cells.
While “staffing your company” is imperative and often emphasized, many commanders centralize critical information, leading to ...