Home › Functions › Lookup & Reference › ROWS
fx
ROWS
Lookup & Reference  ·  Since: Excel 2003  ·  9 languages

Returns the number of rows in a reference or array.

🌐 Translations

English ROWS
Deutsch ZEILEN
Français LIGNES
Español FILAS
Italiano RIGHE
Português LINS
Nederlands RIJEN
Polski ILE.WIERSZY
Русский ЧСТРОК

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

ROWS(array)

Arguments

array (required) — An array, an array formula, or a reference to a range of cells for which you want the number of rows.

▶ Examples

=ROWS(C1:E4)
=ROWS({1,2,3;4,5,6})

Related functions

Copied to clipboard