98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables
Pivot Tables
Resolved · Medium Priority · Version 2010
Tue 11 Oct 2011, 15:51Delegate Norman said...
Norman has attended:
Excel Advanced course
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
Fri 14 Oct 2011, 13:24Trainer Andrew said...
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 information:
See also:
|
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Remove unused toolbar buttonsAre there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following: |
