COLUMNS Function: Summary COLUMN function returns the count of columns selected. First will let you know about the purpose and syntax of the same. Purpose To get the number of columns in an array or selected table range. Arguments & Syntax =COLUMNS(A5:C6) =COLUMNS(array) As given above syntax contain 1 argument, the meaning of the same is given below. Arguments Meaning array In this function selected columns are array, does not matter the same is only columns, columns along with row’s or any data filled table. Translation COLUMNS function we can use to know the column count for the selected range or reference. Selected range can be only columns, can be columns and row’s or any other data filled table bur function will return only columns count. Example:1 Range selected: =(COLUMNS(A5) ...