Counting like results from a logsheet

Thank you NBVC. The formulas did the trick. I am however having problems with getting the Text (Doctors and Modatlities) to copy over to the 2nd sheet. I tried using advanced filters with unique record checked. I had limited success with this. Any ideas on getting the unique text to transfer over like illustrated in my summery sheet example? Ideally, the data would update with each new entry on the log sheet.

Thanks,
Patrick