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
