Spreadsheet: 101645d1299732834-excel-2007-extracting-and-adding-numbers-absence
Sheet: Sheet1

Date | Empolyee | Code | Number | DOW |  | Empolyee | (All) |  |  |  |  |  |  |  |  |  |  | Empolyee | (All)
 | Emp1
 | Emp2 |  |  |  |  | Sum of Number | Column Labels |  |  |  |  |  |  |  |  |  |  | Sum of Number | Column Labels
 | Emp3 |  |  |  |  | Row Labels | A | L | N | O | R | S | U | W | Grand Total |  |  | Row Labels | A | L | N | O | R | S | U | W | Grand Total
 | Emp4 |  |  |  |  | 1-Jan |  |  |  |  |  |  | 4 |  | 4 |  |  | 1 | 12 |  | 9 | 9 | 6 | 3 | 6 | 7 | 52
 | Emp5 |  |  |  |  | 3-Jan |  | 2 |  |  |  | 1 | 5 |  | 8 |  |  | 2 |  |  | 1 | 8 | 4 | 2 | 2 | 7 | 24
 | Emp6 |  |  |  |  | 4-Jan |  |  |  |  | 3 | 5 |  |  | 8 |  |  | 3 | 2 | 4 | 12 | 7 | 8 |  |  | 4 | 37
 | Emp7 |  |  |  |  | 5-Jan | 4 |  |  |  |  |  |  |  | 4 |  |  | 4 | 13 | 6 |  | 11 | 5 | 4 | 5 | 15 | 59
 | [NAME] |  |  |  |  | 6-Jan | 4 |  |  |  |  |  |  | 1 | 5 |  |  | 5 | 4 |  | 12 | 6 | 6 | 9 | 1 |  | 38
 | Emp9 |  |  |  |  | 7-Jan | 5 |  |  |  |  |  |  |  | 5 |  |  | 6 | 9 | 3 | 1 | 6 | 5 | 3 | 1 | 8 | 36
 | Emp1 |  |  |  |  | 8-Jan |  |  |  |  |  |  |  | 4 | 4 |  |  | 7 |  | 9 | 8 | 5 | 10 | 7 | 20 |  | 59
 | Emp2 |  |  |  |  | 10-Jan |  |  |  |  | 4 | 1 |  |  | 5 |  |  | Grand Total | 40 | 22 | 43 | 52 | 44 | 28 | 35 | 41 | 305
 | Emp3 |  |  |  |  | 11-Jan | 4 |  |  |  |  |  |  |  | 4
 | Emp4 |  |  |  |  | 12-Jan |  |  | 4 |  |  |  |  |  | 4
 | Emp5 |  |  |  |  | 13-Jan |  |  | 5 |  | 3 |  |  |  | 8
 | Emp6 |  |  |  |  | 14-Jan |  |  |  | 4 |  |  |  |  | 4
 | Emp7 |  |  |  |  | 15-Jan |  |  | 5 |  |  |  |  |  | 5
 | [NAME] |  |  |  |  | 16-Jan |  |  |  |  | 5 |  |  |  | 5
 | Emp9 |  |  |  |  | 17-Jan |  |  |  | 6 |  |  |  | 1 | 7
 | Emp1 |  |  |  |  | 18-Jan | 2 |  |  | 4 |  |  |  |  | 6
 | Emp2 |  |  |  |  | 19-Jan |  |  | 2 |  |  |  |  |  | 2
 | Emp3 |  |  |  |  | 20-Jan |  | 4 |  |  |  |  |  |  | 4
 | Emp4 |  |  |  |  | 21-Jan |  | 4 |  |  |  |  | 3 |  | 7
 | Emp5 |  |  |  |  | 22-Jan |  |  |  |  |  | 4 |  |  | 4
 | Emp6 |  |  |  |  | 23-Jan |  | 1 | 4 |  |  |  |  | 2 | 7
 | Emp7 |  |  |  |  | 25-Jan |  |  | 3 |  |  |  |  |  | 3
 | [NAME] |  |  |  |  | 26-Jan |  |  | 5 |  |  |  |  |  | 5
 | Emp9 |  |  |  |  | 27-Jan | 1 |  |  |  | 5 | 1 |  |  | 7
 | Emp1 |  |  |  |  | 30-Jan |  |  |  |  |  | 5 |  |  | 5
 | Emp2 |  |  |  |  | 31-Jan |  |  |  |  |  |  |  | 1 | 1
 | Emp3 |  |  |  |  | 1-Feb | 4 |  |  |  |  |  | 2 |  | 6
 | Emp4 |  |  |  |  | 2-Feb |  |  |  | 5 |  |  |  |  | 5
 | Emp5 |  |  |  |  | 3-Feb |  | 1 |  |  | 5 |  |  |  | 6
 | Emp6 |  |  |  |  | 4-Feb | 4 |  | 4 |  |  |  |  | 2 | 10
 | Emp7 |  |  |  |  | 6-Feb |  | 5 |  |  |  |  |  |  | 5
 | [NAME] |  |  |  |  | 7-Feb |  |  |  |  | 8 | 4 |  |  | 12
 | Emp9 |  |  |  |  | 10-Feb |  |  |  |  | 3 |  |  |  | 3
 | Emp1 |  |  |  |  | 11-Feb |  |  |  |  |  | 2 |  | 2 | 4
 | Emp2 |  |  |  |  | 12-Feb |  |  |  |  | 5 |  |  |  | 5
 | Emp3 |  |  |  |  | 13-Feb |  |  |  |  |  |  | 2 |  | 2
 | Emp4 |  |  |  |  | 16-Feb |  |  | 2 |  |  |  |  |  | 2
 | Emp5 |  |  |  |  | 17-Feb |  | 3 |  |  |  |  |  |  | 3
 | Emp6 |  |  |  |  | 18-Feb |  |  |  |  |  |  | 5 |  | 5
 | Emp7 |  |  |  |  | 19-Feb | 1 |  |  |  | 5 |  | 1 |  | 7
 | [NAME] |  |  |  |  | 20-Feb | 2 |  |  |  | 2 |  |  |  | 4
 | Emp9 |  |  |  |  | 21-Feb |  |  | 3 |  |  |  |  |  | 3
 | Emp1 |  |  |  |  | 22-Feb |  |  |  |  | 4 |  |  |  | 4
 | Emp2 |  |  |  |  | 23-Feb |  |  |  |  |  | 4 |  |  | 4
 | Emp3 |  |  |  |  | 24-Feb |  |  |  | 5 |  |  |  |  | 5
 | Emp4 |  |  |  |  | 25-Feb | 2 |  | 4 |  |  |  |  |  | 6
 | Emp5 |  |  |  |  | 26-Feb |  |  | 1 |  |  |  |  | 5 | 6
 | Emp6 |  |  |  |  | 27-Feb |  |  | 2 |  | 2 | 2 |  | 8 | 14
 | Emp7 |  |  |  |  | 28-Feb | 2 |  |  |  | 2 |  |  |  | 4
 | [NAME] |  |  |  |  | 1-Mar |  |  | 1 |  |  |  |  |  | 1
 | Emp9 |  |  |  |  | 2-Mar |  | 1 |  | 4 |  | 1 |  |  | 6
 | Emp1 |  |  |  |  | 3-Mar |  |  | 2 |  |  | 1 |  |  | 3
 | Emp2 |  |  |  |  | [NAME] |  |  |  |  |  |  | 1 |  | 1
 | Emp3 |  |  |  |  | 5-Mar |  |  |  |  |  | 3 |  |  | 3
 | Emp4 |  |  |  |  | 7-Mar | 1 |  |  |  |  |  |  |  | 1
 | Emp5 |  |  |  |  | 29-Dec |  |  | 1 |  |  |  |  |  | 1
 | Emp6 |  |  |  |  | 30-Dec |  | 4 |  | 3 |  |  |  |  | 7
 | Emp7 |  |  |  |  | 31-Dec |  | 1 |  |  |  |  |  |  | 1
 | [NAME] |  |  |  |  | Grand Total | 36 | 26 | 48 | 31 | 56 | 34 | 23 | 26 | 280
 | Emp9
 | Emp1
 | Emp2
 | Emp3
 | Emp4
 | Emp5
 | Emp6
 | Emp7
 | [NAME]
 | Emp9
 | Emp1
 | Emp2
 | Emp3
 | Emp4
 | Emp5
 | Emp6
 | Emp7
 | [NAME]
 | Emp9
 | Emp1
 | Emp2
 | Emp3
 | Emp4
 | Emp5
 | Emp6
 | Emp7
 | [NAME]
 | Emp9
 | Emp1
 | Emp2
 | Emp3
 | Emp4
 | Emp5
 | Emp6
 | Emp7
 | [NAME]
 | Emp9