count all cells not blank code example

Example: excel count non empty cells

=COUNTA(B5:B9)			' NOT BLANK cells
=COUNTIF(B5:B9,"<>")	' other way
=COUNTBLANK(B5:B9)		' BLANK cells