Cellgrids Cellgrids
Home › Excel formulas › Lookup and Reference › COLUMNS

COLUMNS Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

COLUMNS is an Excel Lookup & Reference function. Counts how many columns are in a range.

COLUMNS syntax

=COLUMNS(array)

Arguments

When to use COLUMNS

COLUMNS is used to pull matching data from one part of a workbook into another.

Practice COLUMNS online, free

Open the live Excel-style spreadsheet and try COLUMNS yourself. No Excel install or sign-up needed to start.

Practice COLUMNS now →

More Lookup & Reference functions

Frequently asked questions

What does the COLUMNS function do in Excel?

Counts how many columns are in a range.

What is the syntax of COLUMNS in Excel?

The syntax is =COLUMNS(array). array: The range or array to evaluate.

Where can I practice COLUMNS online for free?

Open the free live spreadsheet on Cellgrids and try COLUMNS yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts