How to query a table with formulas

Tip: How to query a table with formulas

In this video, we’ll look at some formulas you can use to query a table.

Because tables support structured references, you can learn a lot about a table with basic formulas.

On this sheet, Table1 contains employee data. Let’s run through some examples.

To start off, you can use the ROWS function to count table rows. This is the count of data rows only. You can see we have 19 people in the list.

Duration 
3:49
Author 

Leave a Reply

Your email address will not be published. Required fields are marked *