Excel COUNTA Function

Use:

Counts number of non-blank cells in a set of data

Syntax:

COUNTA( range )

Examples:

Cell D12 formula: COUNTA( C4:G4 )

Cell D13 formula: COUNTA( D3:D9 )
Cell D14 formula: COUNTA( C3:G9 )
Cell D15 formula: COUNTA( D3:D9,G3:G9 )

Related Functions:

COUNT, SUM