Microsoft Office Tutorials and References

In Depth Information

Figure 9-15:
The Formula AutoComplete feature is useful when creating a formula that refers to data in a

table.

To refer to a cell in the Total row of a table, use a formula like this:

=Table2[[#Totals],[Sales]]

This formula returns the value in the Total row of the Sales column in Table2. If the Total row in Table2 is not

displayed, the preceding formula returns a #REF error.

To count the total number of rows in Table2, use the following formula:

=ROWS(Table2[#All])

The preceding formula counts all rows, including the Header row, Total row, and hidden rows.

To count only the data rows (including hidden rows), use a formula like this: