Function Rows

Rows()

This function is used to determine the number of rows in a given reference (the range of cells referred to in the function). 


Syntax:

= Rows (Reference_range)

Reference_range: This is the range of cells for which the number of rows is to be determined


Examples: 

The function simply returns the number of rows within the range which is passed on as reference with the function. For example:

• Rows($A$3:$A$3) - result will be: 1 {as there is only 1 row 'A' within the given range}
• Rows($A$35:$A$38) - result will be: 4
• Rows($A$3:$A$5) - result will be: 3
• Rows($A$3:$F$8) - result will be: 6

Application:

Many a times, you have to write a range of formulas (a similar formula over a range of adjacent columns or rows), which should have a number which is dynamic and changes as the row changes. For example - you have to write a formula in cell A5 and the next formula goes in A6, A7, and so on. But in this range of formula, you want one of the parameter to increment by itself. In such a case you can use Rows() function for the dynamic part.

Here is the way the Rows() function would be used in the above example :

= Original formula (Parameter1, Rows($A$5:A5))

Now, when the above formula will be copied to next cell, i.e. A6, it will change to:

= Original formula (Parameter1, Rows($A$5:A6))

Note that $A$5:A5 changes to $A$5:A6 and this will result in 2 which will be passed on as a parameter to the original formula}

Share on Facebook Share on Twitter Share on Google Plus

About Dhakkanz

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.