To count non$-$blank cells in a range, use the formula:

$=$ COUNT $($range$,"\text{'}",1)$

$=$ COUNT $($range$,"\text{'}"\text{'}"\text{'})$

$=$ COUNT $($range$,"\text{'}")$

$=$ COUNT $($range$)$