Hi all,
Currently I have a code set up to count all dates down a column based on 3 criteria throughout its row.
=COUNTIFS($I$2:$I$9709,D3,$G$2:$G$9709,"<>Staff Only Detail",$B$2:$B$9709,"<>PED")
This works just as I'd like it to, counting all "Employee Calls" based on the total number of calls that meet these 3 criteria.
Now I need to calculate unique work days, meaning 1/1/2016, 1/1/2016, 1/2/2016, 1/3/2016 should retrieve a value of 3, instead of 4. However, I still need to use the same criteria from the COUNTIFS function above.
Help is greatly appreciated, Thanks!
Bookmarks