ZCubes Wiki

Manuals/calci/ROWS

Revision as of 16:50, 12 December 2013 by Swapna (talk | contribs)

ROWS(array)

  • where   is an array or reference

ROWS() displays the number of rows in an array or reference.

Description

ROWS(array)

For Example,

ROWS(B4) returns 1.

  •   can be a cell, range of cells or an array.


Examples

ColumnA ColumnB ColumnC ColumnD
Row1 2 3
Row2 5 7
Row3 9
Row4 11
Row5 
=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.

See Also

References

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/ROWS&oldid=196476"