Formula for averaging times

D

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exclude an ID from a Group 1
Pivot Table - Count If 2
VLOOKUP 6
Making a query that isolates records with the latest date 2
Count If formula 2
Average If 4
Pivot Table Calculating Field Help 1
Date columns 1

Top