AVERAGING
 

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???

AVERAGING
 

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

or create a pivot table

--
__________________________________
HTH

Bob

"time conversion" wrote in
message ...
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???

AVERAGING
 

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" wrote:

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

or create a pivot table

--
__________________________________
HTH

Bob

"time conversion" wrote in
message ...
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???

AVERAGING
 

So does the formula do it?

--
__________________________________
HTH

Bob

"time conversion" wrote in
message ...
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" wrote:

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

or create a pivot table

--
__________________________________
HTH

Bob

"time conversion" wrote in
message ...
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???