Explainry Tutorials to Expert in IT

COLUMNS function in Excel


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.



The COLUMNS function has the following argument:

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


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 - 2020 Explainry.com | All Rights Reserved