I have a grid, and I need to know how many full days (Mon-Thu) and How many Half Days (Fri) this person worked in each site. DR. is BJC, the sites are Bel, Tac etc.
Column A is Day, B is date, C is location, D is department.
I tried the countifs, but it seemed really long.