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
To refer to a cell in the Total row of a table, use a formula like this:
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:
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: