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

Answer 1

you can use ROWS or COLUMNS

=ROWS(QUERY(your_query))