Microsoft Office Tutorials and References
In Depth Information
Using SUBTOTAL Instead of SUM to Ignore Rows Hidden by a Filter
Figure 11.18.
Figure 11.18. When you use
for the customer
totals, the problem of creating a grand total becomes simple.
When you use SUBTOTAL
SUBTOTAL instead of
instead of SUM
SUM for the customer
totals, the problem of creating a grand total becomes simple.
Using
Using SUBTOTAL
SUBTOTAL Instead of
Instead of SUM
SUM to Ignore Rows Hidden by a Filter
to Ignore Rows Hidden by a Filter
If you are using a filter to query a data set, you can use the SUBTOTAL
function instead of the SUM function to show the total of the visible rows.
In Figure 11.19 , cell E1 contains a SUM function, which totals rows whether
they are visible or not. Cell E2 contains a SUBTOTAL function. As you use
the AutoFilter drop-downs to show just rows for sales of J730 by Jam-
ie, the SUBTOTAL function updates to reflect the total of the visible rows.
This makes the SUBTOTAL function a great tool for ad hoc reporting.
Search JabSto ::




Custom Search