google sheet : How to find the length of array?

Question

I try to query from other sheet using vlookup() or something similar. I want to count how many array it will produce.

How can i find the length of the output or the resulting array from query() or filter() or vlookup()? Something similar to len() but for counting array.

Thanks

Does [`ROWS()`](https://support.google.com/docs/answer/3093382) do what you want? — Mingwei Samuel, Jun 28 '21 at 03:43

score 5 · Accepted Answer · answered Jun 28 '21 at 07:23

5

you can use ROWS or COLUMNS

=ROWS(QUERY(your_query))

answered Jun 28 '21 at 07:23

player0

124,011
12
67
124

score 2 · Answer 2 · answered Jun 28 '21 at 13:35

It is unclear what you want because we don't know the dimensions of your array or whether you want to count blank cells that may be in the array.

If you want to know only how many rows there are including blanks, then wrap your formula in =ROWS( ).

If you want to know only how many columns there are including blanks, then wrap your formula in COLUMNS( ).

If you want to know how many cells there are in the array total including blanks, then use this pattern (where your formula is placed between each set of parentheses): =ROWS( ) * COLUMNS( ).

If you want to know how many non-null (i.e., not blank) entries there are in the array, then wrap your formula in =COUNTA( ).

google sheet : How to find the length of array?

2 Answers2