In Excel, you might have a long list of orders with a grand total at the end. If you filter the Region column, so the list only shows one region's sales, you'd like the total to include only those items.

If you used the SUM function in the grand total cell, the result won't change [...]