|Please allow to start this response by suggesting that you throw in some punctuation every now and then. It would make your posts and questions a little easier to understand.|
Next, I set up a spreadsheet with your data and modified the example equation you gave (=sum(d2:d5)/sum(c2:c5) to read:
This formula returned 85.83% for Manager 1. Please correct me if I've made an incorrect assumption here.
Finally, to get the same 85.83% for Manager 1 without having to know which rows contain Manager 1, I can use this formula:
The Manager List does not have to be sorted like yours is and the list of Manager names that you are searching for can be in another location. You could have a list on Sheet2 and modify the formula to refer to the ranges on Sheet1. See the Help files for SUMIF or come on back if you need an explanation on how SUMIF works.