COLUMNS

Returns the number of columns in a specified array or range.

Sample Usage

COLUMNS(C5:K15)

Syntax

COLUMNS(range)

• range  - The range whose columns are to be counted. 

Examples

COLUMNS(C5:K25) returns the number of columns in the reference C5:K25 i.e. 9.