I have a workbook that takes data from one program, tracks the hours of all the employees, and produces an upload file for another program (accounting software) that processes payroll. As these employees work multiple jobs a weeks, sometimes even multiple in one day, I need to count the days (unique dates) spent at each job per employee. I've been using their PR Code, Job, and Date as my criteria. I have tried IF/INDEX/MATCH, googled some COUNTIFS, FREQUENCY, UNIQUE, SUMPRODUCT and the best I can get is a return of 1. I don't know if I'm overthinking it? Please help me.