Help with a formula

[Closed]
Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!