How to Count Blank And Non-Blank Cells in MS-Excel

Figuring out the number of non-blank cells in a range is not entirely straightforward. The COUNTBLANK function returns the number of blank cells in a range, but what if you want to count the number of non-blank cells in the same range? One way is to use the COUNTA function:=COUNTA(B1:B13). The problem with this formula […]