Ravi Sir's Cards › Excel
Complaint Ticket Management System in Excel (card 2 of 2)
Revision card 2 for Complaint Ticket Management System in Excel: Met %: =IFERROR(F5/E5,0) gives 75%; Tickets per category: =COUNTIFS(Tickets!$D$5:$D$3000,A11) gives 5; Average hours to resolve: =AVERAGE(Tickets!$I$5:$I$3000) gives 32.2. Includes an example data table.
Read card text
What this card says
2 for Complaint Ticket Management System in Excel: Met %: =IFERROR(F5/E5,0) gives 75%
Tickets per category: =COUNTIFS(Tickets!$D$5:$D$3000,A11) gives 5
Average hours to resolve: =AVERAGE(Tickets!$I$5:$I$3000) gives 32.2. Includes an
Example
data table
Learn this in the lesson: Complaint Ticket Management System in Excel: Priorities, Due-by Time, Hours Taken, Met or Breached and Agent Report