Top Header ADS

ROWS Function in Excel


What is the ROWS function in Excel?

→ The MS Excel ROWS function returns the number of rows in a cell reference or in an array.

→ The ROWS function is a built-in function in Excel.

→ We can put this function into the Lookup/Reference Function category.


How to use the ROWS function in Excel?

→ This function can be entered as part of a formula in a cell of a worksheet.


What is the return value of the ROWS function?

→ The ROWS function returns a numeric value.


What is the Syntax of the ROWS function?

→ The syntax of the ROWS function in Microsoft Excel is:

=ROWS (array)

➨ The Syntax Parameter or Syntax Arguments are:

array - A reference to a cell or range of cells.


👉 Note:

→ The ROWS function returns the count of rows in a given reference as a number.

→ For example, =ROWS(A1:A10) returns 10, since the range A1:A10 contains 10 rows.

→ ROWS takes just one argument, called an array, which can be a range or array.

→ The array can be a range or a reference to a single contiguous group of cells.

→ The array can be an array constant or an array created by another formula.


Examples of ROWS Function

→ We can use the ROWS function to get the row count for a given reference or range or array.

Example-01

→ We will refer to the below photograph, there are 10 rows highlighted in the range B1:E10.

Example of ROWS Function

→ Now as per the syntax we will apply the below formula

=ROWS(B1:E10)

→ That will return as 10.

→ That means 10 rows are available in the selected cell range.

→ Similarly if we want to count the number of rows available into the range A1:Z500 then we can refer to the below formula.

=ROWS(A1:Z100)

→ The formula will return 100.


Example-02

→ We can also use the ROWS function for counting array constant

→ For Better understanding refer to the below example.

→ Now we will apply the formula as per the syntax

=ROWS({1;2;3;5;7;9})

→ That will return 6. The 6 stands for the 6 rows available in the mentioned array.


Example-03 Counting total cells into the selected range

→ There is not any function for counting the number of cells into the selected range, but we can simply count the cells with the help of the ROWS and COLUMNS functions.

→ Refer to the below formula for cell counting

=COLUMNS(range)*ROWS(range)  

→ The above formula will count the total cells available in the selected range

→ Let us take one example for counting the cells between the range A1:O50

=COLUMNS(A1:O50)*ROWS(A1:O50)

→ This will return 750. That means the total cells available in the range A1:O50 are 750 Nos.


👉 For a regular update:

➨ Join us (Telegram Channel)

➨ Join us (LinkedIn Page)


👉 Also Navigate Our Popular Category:

➨ Statistical Functions

➨ Date & Time Functions

➨ Logical Functions

➨ Lookup & Reference Functions

➨ Math Functions

➨ MS Excel Sitemap

➨ 7 QC Tools Excel Templates

➨ Lean Six Sigma Excel Templates

➨ MS Excel Templates

Post a Comment

Previous Post Next Post