M
moonhkt
Hi All
Excel 2003
How to using Formula to calculation Summary
In Incidents Sheet have below column
Date, System, Priority , No. of incidents and Average resolution time
(hours)
e.g,
2010/11/01, A , Low, 1, 1:00
2010/11/01, A, High , 1 , 2:00
2010/11/01,B, Low, 2, 2:00
How to Summary into "Summary Incidents" Worksheet ? Without System
Information
Date, Priority , No. of incidents and Average resolution time
(hours)
2010/11/01, Low ,3,1.667
2010//11/01, High, 1,2:00
moonhkt
Excel 2003
How to using Formula to calculation Summary
In Incidents Sheet have below column
Date, System, Priority , No. of incidents and Average resolution time
(hours)
e.g,
2010/11/01, A , Low, 1, 1:00
2010/11/01, A, High , 1 , 2:00
2010/11/01,B, Low, 2, 2:00
How to Summary into "Summary Incidents" Worksheet ? Without System
Information
Date, Priority , No. of incidents and Average resolution time
(hours)
2010/11/01, Low ,3,1.667
2010//11/01, High, 1,2:00
moonhkt