Excel ROWS Function

Want to learn more about how to count rows in a given reference using excel spreadsheet? This post will give you an overview of how to use formula functions to count rows.

Formula

The generic syntax for Excel ROWS function is:

=ROWS(array)

Array: This is a required argument and can be a cell reference, array or range of cells.

Explanation

The Excel ROWS Function is a reference function. It takes a defined excel range and it returns the number of rows that are contained within the range.

The Excel ROWS function is used to look up the range and give the number of rows in each defined reference or array. Thus, when this function will receive Excel range then it will return the number of rows that are contained within that defined range.

Example

To count the number of rows in a given reference, you can use the Excel ROWS function. In the example selected cell shown, the formula in C5 is:

=ROWS(A5)

A5 showing one cell that’s why the result is only one. ROW function gives you the row number of a specific cell and Excel ROWS function gives you the number of rows in the supplied range.

“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!”
- - Chris T, in California

Leave a Comment

This comment form is under antispam protection

This comment form is under antispam protection

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Trusted by people who work at

Plans & Pricing

I’ll use as many sessions as I want per month

$29.99

/month

Unlimited Sessions

Best offer

I want the unlimited sessions for 3 months AND save money

$74.99

/ 3 months

Unlimited Sessions for 3 months

Save $15 when you buy a subscription for 3 months

I want the unlimited sessions subscription AND save over a hundred dollars