Microsoft Office Tutorials and References
In Depth Information
result to ignore hidden rows. To sum the Sales column and ignore filtered rows, use
either of the following formulas:
Excel provides some helpful assistance when you create a formula that refers to data within a table. Figure 9-15
shows the Formula AutoComplete feature helping create a formula by showing a list of the elements in the
table. The list appeared after I typed the left square bracket.
Here's another example that returns the sum of the January sales:
For an explanation of the SUMIF worksheet function, refer to Chapter 7.
Using this structured table syntax is optional — you can use actual range references if you like. For example,
the following formula returns the same result as the preceding one: