Formulas 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. You can use the COLUMNS function to count columns. To get a total count of table cells, you can use a formula with both functions....