google sheets count non empty cells code example

Example 1: google sheets how to count all non empty cells

# Basic syntax:
=COUNTA(range)

# Example usage:
=COUNTA(A1:B26)

Example 2: number of filled cells google sheets

=SUMPRODUCT(LEN(TRIM(A2:A13))>0)