Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables
|
|
|
The UK's most regular 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. |
Pivot Tables
Resolved · Medium Priority · Version 2010
Reply 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
For upcoming training course dates see: Pricing & availability
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.
|