ROWS(array) returns the number of rows in a reference : ROW « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






=ROWS({1,2,3;4,5,6}) return the number of rows in the array constant
Input the formula: =ROWS({1,2,3;4,5,6})
Input the formula: =ROWS({1,2,3;4,5,6}). Press Enter to get the result.








19.13.ROW
19.13.1.ROW(reference) returns the row number of a referenceROW(reference) returns the row number of a reference
19.13.2.=ROW() returns the row number in which the formula appears=ROW() returns the row number in which the formula appears
19.13.3.=ROW(C4:D6) returns the first row in the reference=ROW(C4:D6) returns the first row in the reference
19.13.4.ROWS(array) returns the number of rows in a referenceROWS(array) returns the number of rows in a reference
19.13.5.=ROW(Scores) returns the first row of the Scores range=ROW(Scores) returns the first row of the Scores range