COLUMNS (number of columns in a range)

<< Click to Display Table of Contents >>

COLUMNS (number of columns in a range)

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