Help with a formula

Closed
Jean - Nov 17, 2009 at 04:05 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 17, 2009 at 10:06 PM
Hello,
Here is my problem (other than I am not good at formulas and can;t even begin to figure this one out). We handed out a survey to our patients. Asked them who there doctor was, and what kind of satisfaction they got from the visit. I am looking for a formula for A61
in worsheet "FY10", cells A2-A60 is the list of which of 4 doctors (Dr 1,2,3,4- each had about 10-20 surveys returned as the doctor the patient saw). In cells B2-B60 is a number from 1-5 representing levels of satifaction. (5 very satisified, 4-met expectations, etc) In cell A61 i want to know for Dr 1 (there may have been 17 survyes in the 60 returned), what was his average score.

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 17, 2009 at 10:06 PM
A61 1
A62 2
A63 3
A64 4

In B61 type this formula
=AVERAGE(IF($A$2:$A$60=A61,$B$2:$B$60))


INVOKE THIS FORMULA BY HITTING CONTROL+SHIFT+ENTER

Copy B61 down from B62 to B64

If this is ok post confirmation
0