Look up value and sum all values from another column

[Joe Payne]

I have made a simple excel workbook to keep doctors payments. I created drop down boxes to populate with the doctors name. I need to find all like values in column A and then auto-sum all values from corresponding column D (the payment to that doctor). I would like to link the info to sheet2 so the doctors name and the sum show up there. I hope I have explained this properly. I will share the workbook if that is possible so you can maybe better understand what I am trying to do. Thanks. Joe Payne

 

[Eric W]

Try:

=SUMIF(Sheet1!A:A,F1,Sheet1!D:D)

where the doctor's name is in F1.