Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging | Excel Worksheet Functions | |||
averaging | Excel Discussion (Misc queries) | |||
Averaging | Excel Discussion (Misc queries) | |||
averaging & ??? | Excel Worksheet Functions | |||
Averaging best 15 out of 20? | Excel Discussion (Misc queries) |