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.
Excel Function
COLUMNS
Returns number of columns in an array.
COLUMNS(array)Arguments
array
RequiredSpecify 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)).
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
3
Practice This Function
COLUMNS FAQ
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.