time conversion wrote:
I have one column in a pivot table contains numerous Doctors. In an adjacent
column I have the minutes that it takes them to do a task.....some have more
then one instance of that task...for example:

Column A Column B Column C Column D
(average)
Doctor 1 Repair Bone 53 49.75
50
29
67

How can I write a formula to find that average for a very long list of
Doctors and tasks??

There's no need to write a formula based on your example (although you
could). Take Column D out out the picture. I'm assuming Columns A and B
are "row area" breaks. It looks like you have Time in the row area also
-- drag this to "data area". It will probably default to "Count of
Time". No matter, simply double click the "Count of Time" button (or
right click an actual count of time value and pick "Field Settings"),
and change it to summarize as Average.

If the subtotals are annoying, double click the "Doctor" button and
select "None" under Subtotals.