Formualizer Docs
ReferenceFunctionsLookup Functions

ROWS

Returns the number of rows in a reference or array.

Summary

ROWS reports height, not data density.

Remarks

  • For a single cell reference, returns 1.
  • For full-column references (for example A:A), returns 1048576.
  • For array literals, returns the outer array length.
  • Invalid references return an error.

Examples

Count rows in a contiguous range
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
9
Count rows in a full column reference
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1048576

FAQ

Does ROWS count populated rows or reference height?

ROWS returns reference height only; blanks inside the range do not reduce the count.

How does ROWS behave for full-column references?

A full-column reference (like A:A) returns the sheet row limit, 1048576.

Runtime metadata

Category

Lookup

Signature

ROWS(arg1: Any (Range))

Arity

min 1, max 1

Arguments

arg1

Any · Range

Caps

PURE

Source

crates/formualizer-eval/src/builtins/lookup/reference_info.rs

Registration entry at crates/formualizer-eval/src/builtins/lookup/mod.rs.

ROW

Returns the row number of a reference, or of the current cell when omitted.

SEQUENCE

SEQUENCE: Generates a sequential numeric array with configurable size, start, and step.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes ROWS count populated rows or reference height?How does ROWS behave for full-column references?Runtime metadata