Excel COLUMNS Function

HomeExcel FunctionsExcel COLUMNS Function (Example + Sample File)

What is EXCEL COLUMNS FUNCTION

The Excel COLUMNS Function is listed under Microsoft Excel's Lookup Functions category. It returns the number of columns referred to in the given reference. In simple words, it counts how many columns are there in the supplied range and returns that count.

How to use it

To learn how to use the COLUMNS function in Excel, you need to understand its syntax and arguments:

Syntax

COLUMNS(array)

Arguments

  • array: An array or range of cells from which you want to get the number of columns.

Notes

  • You can also use a named range.
  • COLUMNS function is not concerned with the values in the cells, it will simply return the number of columns in a reference.

Example

To master COLUMNS function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used COLUMN to get the number of columns from range A1:F1.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.