Go Back

Excel COLUMNS Function

What is Excel COLUMNS Function?

Excel Columns function returns the number of columns that are contained in an array or reference. It helps you to easily know the column count without necessarily counting.

Formula

=COLUMNS(array)

Parameters of Excel COLUMNS function

The COLUMNS function has the following parameter:

array (required) – A reference to a range of cells for which you want the number of columns.

How to use the Excel COLUMNS function

The purpose behind using the COLUMNS function in Excel is to return the number of cells in the column of a specified array or reference. Using columns A and B in the example below for better illustration.

  1. Input your necessary data into the cells of each column in the worksheet.

Figure 1. Example of how to use the COLUMNS function.

2. Apply the COLUMNS function. The reference here is B2:C2.

Figure 2. The COLUMNS function formula showing the ‘array’ argument.

3. The COLUMNS function finally calculates the range or the total number of columns present.

Figure 3. The COLUMNS function calculates the total columns present.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

hello i have 1000's of columns but those columns are repeated after every 10 columns, how to split them?
Solved by E. Y. in 18 mins
filtering columns in pivot table witjh columns outside
Solved by G. H. in 18 mins
I need help with comparing columns and copying columns
Solved by C. A. in 22 mins

Leave a Comment

avatar