Formula for averaging times

[Guest]

I have a very large spreadsheet that tracks times. I have the formulas
figured out fot the wait times that I need but I need to break them down by
individual. There are approximately 15 different physicians listed in this
spread sheet. I have a separate spreadsheet that I want to average the times
for each physician.

Example:

Physician 1 "time to see physician" "wait time" "elapsed time"
Physician 3 "time to see physician" "wait time" "elapsed time"
Physician 1 "time to see physician" "wait time" "elapsed time"
Physician 4 "time to see physician" "wait time" "elapsed time"
Physician 2 ....... and so on.

There are about 3000 entries one each spread sheet. How can I get the
Average Wait Time for Physician 1, Physician 2, etc. without having to sort
the sheet by physician. Is there a formula that can be used?

Thanks for any help.

 

[Guest]

A copuple of ways

=SUMIF(A2:A50,"Physician1",C2:C50)/COUNTIF(A2:A50,"Physician1")

or

=AVERAGE(IF(A2:A50="Physician1",C2:C50))

the latter entered with ctrl + shift & enter

better maybe to put the criteria (the physician's name) in a separate cell
then you only have to change the contents of that cell

=SUMIF(A2:A50,E1,C2:C50)/COUNTIF(A2:A50,E1)

or

=AVERAGE(IF(A2:A50=E1,C2:C50))


Regards,

Peo Sjoblom