The status bar shows 37 for me with that filter, which is the same number that your formula results in. Also, filtering just on Dental in column C gives a total of 204 in the status bar, which is also the total in your summary sheet, so I don't see that you are missing any values.

Hope this helps.

Pete