Related Function:

The COLUMNS function takes an range of cells in an Excel worksheet and returns the number of columns that are contained within the range.

Syntax

=COLUMNS(array)

Arguments

Argument Description
array The range of cells that you want to know the number of columns in

Examples

  A B C
1 Formula Results Notes
2 =COLUMN(B1) 1  
3 =COLUMN(B1:E5) 4  
4 =COLUMN(1:1) 16384 Function was calculated in Excel 2010. Therefore, the formula returns the value 16,384 (the number of columns in Excel 2010). The same result would be returned in Excel 2007. The function would return the value 256 in Excel 2003.