Using the thread method, You need to insure that it counts first, sercond,
etc interviews separately
if the data is sorted so that the first interviews are all above the second
and so forth
change the B$2 reference at the top of each group to the top row reference.
if they are not grouped, the equation needs to be changed to something like
a sumproduct with appropriate references to do the job.
How are they groups and what lets you know whether it is first second or
third interview?

"BW.Wooster" wrote:

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!