Returns the number of columns in the given reference.
Array is the reference to a cell range whose total number of columns is to be found. The argument can also be a single cell.
=COLUMNS(B5) returns 1 because a cell only contains one column.
=COLUMNS(A1:C5) equals 3. The reference comprises three columns.
=COLUMNS(Rabbit) returns 2 if Rabbit is the named range (C1:D3).