COLUMNS Function

About

COLUMNS function in Excel returns the number of columns in a reference.

Function Type

Lookup and reference

Purpose

Get the count of columns in a reference

Return value

Number of columns

Syntax

=COLUMNS(array)

Arguments

array – a cell reference or a range reference.


Example


Notes

COLUMNS function doesn’t accept multiple references.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel