filter and subtotal

I am creating a document were the data is listed simply as:
Column A Column B Column C
ABC hospital dept 1 Dr.A 500
Dr. B 200
Dr C 300

ABC hospital dept 2 Dr.A 300
Dr. B 200
Dr C 400

I have utilized =SUBTOTAL(109,(D9:D3684)), so I can get the total of the visual number after auto and manual hiding, but this is just using the first line total, i.e.
ABC hospital dept 1 Dr.A 500
or if I select multiple department in auto filter they subtotal only reflects
ABC hospital dept 1 Dr.A 500
ABC hospital dept 2 Dr.A 300
not the numbers associated with all the doctors in that department. Does anyone now the formula, so I can filter for all the lines associated with a particular heading-keeping in mind the the amount of doctors in each column is variable.

Any assistance would be greatly appreciated. Thanks!

what excel year are you working with

2007. thanks!