excel


Excel: A few useful functions

count() Counts all cells that contain numbers only.

counta() Counts all cells that contain any content (both numbers and text) a.k.a. are not empty.

countblank() Counts all cells that are empty.