ROWS Function

P

plumstone

In Office Help, there is an example of the FOWS Function. In B2, the fumula is :
"=ROWS(C1:E4)" I believe this one is easy to understand. However, another fumula in cell A3 said:
=ROWS({1,2,3;4,5,6})
The description about it is "Number of rows in the array constant". The result is "2". Could you please explain it in a easy way for me to understand? Thanks.
 
I

icestationzbra

the example mentions 2 arrays. the rows function is supposed to retur
the number of rows in any given array.

first: "=ROWS(C1:E4)"

C1 D1 E1
C2 D2 E2
C3 D3 E3
C4 D4 E4

this is a 4 x 3 matrix, 4 being the number of rows.

second: "=ROWS({1,2,3;4,5,6})"

the way to depict a set is by using braces '{' and '}'.

hence, {7, 8, 9, 0} would be a 1 x 4 matrix.

if i were to depict a matrix that has more than one row, in the form o
a set, i would have to use the separator ';'.

hence, {7, 8; 9, 0} would be a 2 x 2 matrix.

the semicolon is a sort of delimiter for each row in a matrix.

hope that was helpful
 
Top