I got help yesterday and hopefully can today.

I now need a formula to count the number of "n/a" by each person.

ER MD WAIT TIME TO SEE PHYSICIAN
smith n/a
harris 0:21
david n/a
david 0:43
smith 0:25
harris 0:18
harris n/a

Again, this is the same sheet and has about 2500 entries for one month. I
need to find out what physicians had a wait time of "n/a" without having to
sort the entire sheet by physician.

Thanks.