will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Total a Filtered List in Excel
Posted on November 11th, 2008 by Debra Dalgleish
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 if [...]
Filed under: Excel, Functions | 2 Comments »
