Excel Function

ROWS

Returns number of rows in an array.

ROWS(array)

Arguments

array

Required

Specify a reference range. You can drag or click start/end cells.

Practice Preview

Use ROWS to return the result with these settings (Target range: B2:D8 (columns B to D)). You can set ranges by dragging from the start cell to the end cell in the same argument field.

Example Table

#	AProduct ID	BProduct Name	CPrice	DStock
2	P001	Apple	120	80
3	P002	Banana	98	120
4	P003	Notebook	450	35
5	P004	Pen	300	60
6	P005	Grapes	150	45
7	P006	Ruler	250	20
8	P007	Peach	86	55

How to Use (Formula)

=ROWS(B2:D8)

Result

Practice This Function

Start Function Practice Back to Function List

ROWS FAQ

How do I use ROWS in Excel?

Use ROWS when you want to count rows in a range. Enter Target range in that order, then add optional arguments when needed.

Where can I practice ROWS?

Use the "Start Function Practice" button to jump straight into ROWS drills.

What arguments does ROWS use?

The main arguments are Target range. Enter them in order.