deepcalc
DocsCOLUMNS

COLUMNS

View as markdown/docs/functions/columns.md Ask Claude about this pageOpens Claude with this page's address

Returns number of columns in a reference.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=COLUMNS(A1:D3)
ABCD
1 102alpha2026-01-15
2 204beta2026-03-31
3 306gamma2026-12-01
Result 4

Syntax

COLUMNS(array)
array
range required
ABSReturns absolute value of a number. ACOSReturns arccosine of a number. ACOSHReturns inverse hyperbolic cosine. ACOTReturns the arccotangent of a number. ACOTHReturns the inverse hyperbolic cotangent. ADDAdds two numbers: sheets exposes the + operator as a function.