Archive of Mr Excel Message Board

Back to Pivot Tables in Excel archive index
Back to archive home

Averages in Excel 97 Pivot Tables

Posted by Dave on January 20, 2000 2:06 PM

I have an Excel 97 database with Months in one of the columns, and sale volumes in the next. When I use Pivot Tables to summariz the sales by month, I want to get the average for the months displayed, instead of Grand Totals. I can't find any functions in the Help pages which will do this. Can anyone help?

Re: Averages in Excel 97 Pivot Tables

Posted by JAF on January 21, 2000 8:01 AM

Once you've dragged the sales volume data into the "data" area on the Pivot Table Wizard, double click it and select Average from the list of options. You can also do Sum, Count, Max, Min, Product, Count Nums as well as some highly interesting statistical functions.

Hope this helps.
JAF

Re: Averages in Excel 97 Pivot Tables

Posted by Dave on January 21, 2000 2:03 PM

Thanks jaf, but unfortunately that doesn't give me what I need - it produces an average figure for each month. What I am looking to do is to produce an average for the whole year i.e the sum of the 12 months divided by 12. I need this average figure to replace the Grand Totals which is produced as part of the standard Pivot Table summary

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.