Help with formula to count unique records Hello!

I am fairly new to excel, so I appreciate any help here.

I am trying to count the number of unique health, vision, and dental records on an invoice using employee ID numbers. I've attached an example excel invoice and the count formulas I've tried.

In the example sheet, you'll...
https://www.excelforum.com/sho....wthread.php?t=142363