pivot tables

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

# Pivot Tables

Resolved · Medium Priority · Version 2010

Norman has attended:

### Pivot Tables

From pivot table below how do I do a count of the number of 6 figure digits below 9,510 9,530 and 9,540 in the first column.

Column Labels
4
Row Labels Sum of ValueCOCur Count of ValueCOCur2
9,510 7,639 25
142,939 1,516 5
178,046 3,923 12
191,249 2,199 8
9,530 1,897 1
(blank) 1,897 1
9,540 19,647 57
140,831 817 3
141,128 790 3

### RE: Pivot Tables

Hi Norman

Thank you for your question. As a first thought perhaps the countif funtion might help. Adding =COUNTIF(A1:A9,">99999") at the bottom would count values that match certain criteria. You may need to adapt the criteria to suit your requirements.

Let me know if this helps or if you have further questions.

Kind regards,
Andrew

Fri 21 Oct 2011: Automatically marked as resolved.

Training courses

Training information:

 Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

### Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

View all Excel hints and tips