agents

Hello all, I have individual sheets in a workbook named for each Shipping Agent at my workplace. In these sheets they log their parcel counts as they ship an order. They must (it's a required field) select their name from a drop-down list in column J:J so that another sheet can calculate their...

Hello, I am trying to perform a task similar to what a COUNTIFS would do but I can't seem to get it. Columns A-F are used. I have agents, a work week (IE F--MTWR), start time and Criteria. # of agents or column D is where the formula is. Example: If I want to see how many people have a 6:30 AM...

Hi All Hope you all are well I have 2 sets of data where agents are scheduled to do an activity and another set of data of what agents actually did I have listed a set of start and stop times for a paticular agent on that day Agents are assigned to a group so there could be 10 agents in...

Good afternoon, all! Hopefully I explain this well. I'm working on summarizing data and I have four different criteria that I want to be able to "filter" the data by, each with a couple of different options. The first two criteria are a start and end date - That's simple. CountIf between those...

Hello, I am looking to perform a SUMIF but with names. For example, say there are different supervisors in column A and I want to find the amount of agents a particular supervisor has listed in column B (without doing a filter). Say supervisor JOHN CLOUD is in Column A2 and then in random rows...