COLUMNS

Description

COLUMNS returns the number of columns in a range reference.

Syntax

COLUMNS ( range )

 

Parameter

Description

range

A reference to a range of cells.

Example

This function returns 4:

COLUMNS(A1:D5)

Also, see

COLUMN

ROWS