Hi all,

I have been looking for a way extracting some data from an excel
spreadsheet and have been told pivot tables are the way to do this.
However the 'count' option which appears at the end of each group is
adding up the totals rather than counting the number of instances. For
Example, this is my table:

------
Count of contact type

Status Last Name Total

First Interview Smith 6
Jones 2
Withers 3

First Interview Count 11

Second Interview Smith 2
Jones 2
Withers 1

Second Interview Count 5

------

What I would like is for the 'Count' column to show the number of
instances rather than a total, like this:

------
Count of contact type

Status Last Name Total

First Interview Smith 6
Jones 2
Withers 3

First Interview Count ?? 3

Second Interview Smith 2
Jones 2
Withers 1

Second Interview Count ?? 3

------

I have tried a variety of options, including adding following these
instructions:

http://groups.google.co.uk/group/mic...rnum=3 &hl=en

But that does not seem to provide the answer.

Any help would be greatly appreciated as I have to go through at the
moment counting the rows manually!