Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

COLUMNS

Count all columns of a cell range in Excel
Returns the number of columns in a reference

Rational

Count all columns of a cell range.

Description

The Excel COLUMNS function returns a count of all columns of a cell range or array formula.
For example, =COLUMNS(E10:F100) returns 2 (two columns in the range i.e. E & F).

Syntax

=COLUMNS (array)

Parameters

array – A reference to a cell range

Return Value

An integer representing a total number of columns.

Key Notes

  • The COLUMNS function returns the count of all columns in the specific cell range, unlike COLUMN function that returns column number of the first cell in reference.
  • The function accepts an array or array formula, or a reference to a range of cells.

Keep Reading Similar Functions:

Find column number for a reference in Excel

COLUMN

The COLUMN function returns the column number of a first reference cell. For example, =COLUMN(E10:F10) returns 5 (5th column, a sequence of E in alphabets).

Read More »
Find ROW number of a reference in Excel

ROW

The ROW function returns the row number of a reference cell. For example, =ROW(E9:E10) returns 9 (9th from top to bottom, only the first cell).

Read More »
Count of rows in a cell range in Excel

ROWS

The ROWS function returns the number of rows of a cell range or array formula, =ROWS(E10:F100) returns 91 (91 rows in the cell range i.e. 10 to 100).

Read More »
Return address of a cell in Excel

ADDRESS

The ADDRESS function returns cell address from given row and column numbers of a worksheet. For example, if you pass ADDRESS(5,6) the function returns $F$5.

Read More »
Find number of areas in reference in Excel

AREAS

The AREAS function returns a number of areas or region. I.e., =AREAS((B2:C4,D8:F9)) returns 2 (number of areas), include extra sets of parentheses.

Read More »