# Help with a formula

Closed
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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.

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
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