COLUMNS

The COLUMNS function returns the count of columns in a given reference as a number. For example, COLUMNS(A1:C3) returns 3, since the range A1:C3 contains 3 columns. COLUMNS takes just one argument, called array, which should be a range or array. Use the COLUMNS function to get the column count for a given reference or range. For example, there are 6 columns in the range A1:F1 so the formula below returns 6: The range A1:Z100 contains 26 columns, so the formula below returns 100: You can also use the COLUMNS function to get a column count for an array constant: Although there is no built-in function to count the number of cells in a range, you can use the COLUMNS function together with the ROWS function like this: