calls

I am trying to create a spreadsheet to track attendance In the rows I have listed Calls, Meeting and Training by month The columns are for each person I would like to set the conditional formatting on each row to turn the number red if it is below the total calls, meetings or training that is...

Hi All I have a table with 6 columns; Agent - Staff Member Called - Phone number called Internal/External - Where the call went Date - Date of Call Time - Time of Call Length - Length of Call I am trying to build a Pivot Chart, which shows the average number of calls made by each agent at...

Hello, I have been having some issues getting sumproduct to work and ignores errors and only focus on numbered cells. Example is I'm trying to get the weighted average of average handle times against the number of calls taken per person. Example sumproduct is = sumproduct(handle times, # of...

Hello All I have a spreadsheet with 2 Pivot tables on it. One shows the numbers of Phone Calls The second shows the average length of those calls. Is it possible to show both of these values in one Pivot table in the same cell? I would want both these values separated by a hyphen. Also, does...

Good Afternoon I have a spreadsheet with 2 tabs on "Calls Inbound" where the data is stored and "Calls Inbound Overview" where I have an overview. I am trying to count how many times a call is taken between set times and I am having no look. The date ("A") and time ("B") are in "Calls...

hi - I have two spreadsheets... and trying to use a VLOOKUP formula (Or something similar if there is better) to basically do the following: - Spreadsheet A has a product name - say "Color Hair Care" - Spreadsheet B has a more detailed product name and a UPC code (separate columns) - "Color...

Help! I'm trying to simply count up the number of opened and closed tickets to tally them up and I can't seem to get my cells referenced correctly. P.S. I've only been coding vba for two days so cut me some slack xD i'm sure it's easy. the sheet is called data and the ticket status is in...