writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + Line 7:
Line 7: − + Line 13:
Line 13: − + Line 60:
Line 60: − + +
no edit summary
== ROWS(array) ==
== ROWS(arr) ==
*where <math>array</math> is an array or reference
*where <math>arr</math> is an array or reference
ROWS() displays the number of rows in an array or reference.
ROWS() displays the number of rows in an array or reference.
== Description ==
== Description ==
ROWS(array)
ROWS(arr)
For Example,
For Example,
ROWS(B4) ''returns 1''.
ROWS(B4) ''returns 1''.
*<math>array</math> can be a cell, range of cells or an array.
*<math>arr</math> can be a cell, range of cells or an array.
=ROWS(D4) : Calculates the row number of cell D4. ''Returns 4'' as a result.
=ROWS(D4) : Calculates the row number of cell D4. ''Returns 4'' as a result.
=ROWS(A2:C5): Calculates the row number in the range A2 to C5. ''Returns 4'' as a result.
=ROWS(A2:C5): Calculates the row numbers in the range A2 to C5. ''Returns 4'' as a result.
=ROWS({3,4;6,7;8,9}): Calculates the number of rows from the given array. ''Returns 3'' as a result.
== See Also ==
== See Also ==