Formula for averaging times

[Denise]

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.

[Peo Sjoblom]

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

"Denise" wrote:

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