Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

COLUMNS

Description: Based on an array or reference, returns the number of columns.

Syntax: COLUMNS(Array)

• Array is an array or array formula, or a reference to a range of cells for which you want the number of columns.

Example:

• COLUMNS(C1:E4) = 3 [the number of columns in the reference]

• COLUMNS({1, 2, 3; 4, 5, 6}) = 3 [the number of columns in the array constant]