Average If

D

Denise

Sorry for reposting this...

I need a formula to figure the average in one column if for a specific
person in another. There are about 2500 entries for each sheet. I need to
know the average with time for Smith, Samsone, etc. without having to sort by
physician.
Thanks.


ER MD WAIT TIME TO SEE PHYSICIAN
smith 0:15
samsone 0:21
terry n/a
terry 0:43
hanson 0:25
smith 0:18
terry n/a
samsone 0:31
 
P

Peo Sjoblom

=AVERAGE(IF(NAme_Range="Smith",Time_Range))

array entered ctrl + shift & enter

Regards,

Peo Sjoblom
 
P

Peo Sjoblom

Did you enter it with ctrl + shift & enter or does any of your ranges include
a #NUM! error or are you using the whole range like A:A? My guess the last
one, if so change the range to something less like A2:A5000..

This formula should yield the same result,

=SUMIF(Name_Range,"Smith",Time_Range)/COUNTIF(Name_Range,"Smith")

also a good idea is to replace the hard coded names (Smith) with a cell
where you would put the names, that way you won't have to edit the formula
again

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

Top