Excel Function

COLUMNS

Returns number of columns in an array.

COLUMNS(array)

Arguments

array

Required

Specify a reference range. You can drag or click start/end cells.

Practice Preview

Use COLUMNS to return the result with these settings (Target range: B2:D8 (columns B to D)). You can set ranges by dragging from the start cell to the end cell in the same argument field.

Example Table

#	AProduct ID	BProduct Name	CPrice	DStock
2	P001	Apple	120	80
3	P002	Banana	98	120
4	P003	Notebook	450	35
5	P004	Pen	300	60
6	P005	Grapes	150	45
7	P006	Ruler	250	20
8	P007	Peach	86	55

How to Use (Formula)

=COLUMNS(B2:D8)

Result

Practice This Function

Start Function Practice Back to Function List

COLUMNS FAQ

How do I use COLUMNS in Excel?

Use COLUMNS when you want to count columns in a range. Enter Target range in that order, then add optional arguments when needed.

Where can I practice COLUMNS?

Use the "Start Function Practice" button to jump straight into COLUMNS drills.

What arguments does COLUMNS use?

The main arguments are Target range. Enter them in order.