COLUMNS (number of columns in a range)

Navigation:  Formulas and functions > Functions from A to Z >

COLUMNS (number of columns in a range)

Previous pageReturn to chapter overviewNext page

Syntax:

COLUMNS(Range)

Description:

This returns the number of columns in the specified cell range.

Example:

COLUMNS(A1:D5) returns 4

See also:

ROWS, COLUMN, AREAS