AVERAGING

[time conversion]

I would like to learn how to get an average using a formula for for varying
groups of numbers.
for example:

Surgeon Operation Operation Time in Minutes

A Hernia 38 (1st Occurence)
31 (2nd)
59 (3rd...etc)
28
22
39

so the average TIME IN MINUTES for that Hernia operation is 36.16 minutes

my question is...how do I write a formula to find the averages for Multiple
physicians doing Multiple procedures???

 

[Bob Phillips]

=SUMPRODUCT(--(surgeon_range=surgeon),--(op_rage=op),time_range)
/SUMPRODUCT(--(surgeon_range=surgeon),--(op_rage=op))

or create a pivot table

 

[time conversion]

Hey Bob...thanks for the info...but I the data I'm averaging is already
within a pivot table. What I've been doing so far is capturing the times in
the cells and looking at the toolbar at the bottom for the average....then
typing that in the cell to the right of the Surgeon and Procedure. Very
tedious....

 

[Bob Phillips]

So does the formula do it?