Easy Explanation Notes with Examples

COLUMNS function in Excel

Use

The COLUMNS function uses to find out the number of columns in a selected array or reference. For example, =COLUMNS(D2:F3) returns 3, because the range D2:F3 contains three columns.

Syntax

COLUMNS(array)

The COLUMNS function has the following argument:

Array – Required. A reference to a range of cells for which to want the number of columns.

Example

For more detail and examples, visit Microsoft Office website.

Related Functions

COLUMN function returns the column number against the given cell reference.

ROWS function returns the number of columns in a reference or an array.




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved