deepcalc
DocsROWS

ROWS

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

Returns number of rows in a reference.

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

Examples

=ROWS(A1:A10)
A
1 10
2 20
3 30
4 40
5 50
Result 10

Syntax

ROWS(array)
array
range required
ADDRESSReturns a cell address as text from row and column numbers. AREASReturns the number of areas in a reference. HLOOKUPSearches first row and returns matching value. HYPERLINKThe text a link displays: clickability is the renderer's. INDEXReturns value at row and column in range. INDIRECTReturns reference specified by text string.