Excel formula translator
Translator
Functions
Translation table
Error codes
Academy
🔍
Search functions
🌐 EN ▾
English
Deutsch
Français
Español
Português
☰
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 version
Available
Excel 2007
✓
Excel 2013
✓
Excel 2019
✓
Excel 2021
✓
Microsoft 365
✓
Translate a formula with this function
fx
EN
=ROWS(C1:E4)
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
ADDRESS
AREAS
CHOOSE
CHOOSECOLS
CHOOSEROWS
COLUMN
COLUMNS
DROP
Copied to clipboard
↑
↓
·
Enter
·
Esc
Excel functions ›