COLUMNS

Definition: COLUMNS is a function that returns the number of columns in an array.

Syntax: =COLUMNS(array)

Situation: This formula is suitable when you need to retrieve the number of columns in an array for use in a calculation.

Example: If you have an array A1:B5, the number of columns can be found using the formula =COLUMNS(A1:B5), which returns 2.