Pivot Table

The UK's most regular instructor-led training courses.
Training information: excel 2003 training course · Excel in courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Pivot Table

Bronwynn has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Bronwynn [2 posts] (2008 Mar 5 Wed, 15:58) Reply

When I create a pivot table when I bring across the inforamtin into the layout, why does it always say count of instead of sum of?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	3	book now	£475	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Pivot Table

by - trainer Rich platinum contributer [711 posts] (2008 Mar 9 Sun, 10:37) Reply

Hello

The default depends on where in the pivot table you put your data. If you have a column of dates for example and you drop them in the 'drop data items here' section then it will do a count because there is nothing to sum because you cannot sum dates. If you are putting something in this section which is the value you want to sum or count so numeric values then it should go to sum. If it does not then double click where it says count and it should bring up the screen that lets you select if you want count, sum etc.

thanks
Rich

· Prepare for your MOS Certification with MS Excel Courses
· Microsoft Excel Training: Essential for Today's Employees
· A Beginners Guide To Formulas In Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· How to Create Better Excel Spreadsheets: Part Two

Please browse our web site to find out more about
excel 2003 training course and other Microsoft training courses.

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips