COUNT and COUNTA

Count numeric records or all non-empty cells in a range.

Practical example

=COUNTA(A2:A100)

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.