Formula or code require to match 3 criteria for different cell

[Harry_1989]

Hi Friends,
i am stuck in below attached working file, where i am looking code or formula that will the details for call,training,free,meet for employees (A to F) for all days in Aug month . The criteria is formula/Code should check with data provided in sheet 2 that if employee i.e A to F matchs and date is matching and lastly the if its details (call,training,free,meet ) matching i.e all 3 criteria match than return sum of that activity for that employee for that date.
e.g on 3 aug employee A was in Meet for 30 mintus as per sample data .
Can any one of you please reply urgently if possible, that will really helpful for me.

Sheet 1 contains

A	1-Aug	2-Aug	3-Aug	4-Aug	5-Aug	6-Aug	7-Aug	8-Aug	9-Aug	10-Aug	11-Aug	12-Aug	13-Aug	14-Aug	15-Aug	16-Aug	17-Aug	18-Aug	19-Aug	20-Aug	21-Aug	22-Aug	23-Aug	24-Aug	25-Aug	26-Aug	27-Aug	28-Aug	29-Aug	30-Aug	31-Aug
Total Working Time (Hrs)	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510
Less: (-) Breaks
Call
Training
Free
Meet
Effective Time	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510	510
Sheet 2 contains Task Name Name Time Date Do not take A 3 2015-08-03 Do not take B 11 2015-08-03 Free C 15 2015-08-03 Training D 195 2015-08-03 Training E 195 2015-08-03 Do not take F 15 2015-08-03 Do not take A 12 2015-08-03 Free B 15 2015-08-03 Free C 18 2015-08-03 Meet D 10 2015-08-03 Training E 5 2015-08-03 Do not take F 35 2015-08-03 Do not take A 3 2015-08-03 Training B 195 2015-08-03 Free C 15 2015-08-03 Free D 18 2015-08-03 Meet E 10 2015-08-03 Do not take F 17 2015-08-03 Do not take A 13 2015-08-03 Free B 15 2015-08-03 Meet C 10 2015-08-03 Training D 10 2015-08-03 Free E 18 2015-08-03 Free F 18 2015-08-03 Training A 120 2015-08-03 Free B 15 2015-08-03 Training C 195 2015-08-03 Do not take D 73 2015-08-03 Do not take E 3 2015-08-03 Training F 450 2015-08-03 Meet A 10 2015-08-03 Free B 18 2015-08-03 Training C 75 2015-08-03 Free D 18 2015-08-03 Meet E 26 2015-08-03 Meet F 0 2015-08-03 Do not take A 5 2015-08-03 Do not take B 1 2015-08-03 Free C 18 2015-08-03 Free D 18 2015-08-03 Meet E 10 2015-08-03 Training F 5 2015-08-03 Meet A 10 2015-08-03 Free B 18 2015-08-03 Training C 480 2015-08-03 Training D 450 2015-08-03 Free E 18 2015-08-03 Meet F 10 2015-08-03 Free A 18 2015-08-03 Meet B 10 2015-08-03 Free C 18 2015-08-03 Do not take D 5 2015-08-03 Do not take E 3 2015-08-03 Training F 15 2015-08-03 Meet A 10 2015-08-03 Free B 18 2015-08-03 Training C 60 2015-08-03 Meet D 16 2015-08-03 Free E 18 2015-08-03 Training F 15 2015-08-03 Training A 75 2015-08-03 Free B 18 2015-08-03 Meet C 16 2015-08-03 Meet D 20 2015-08-04 Do not take E 149 2015-08-04 Do not take F 1 2015-08-04 Do not take A 42 2015-08-04 Do not take B 20 2015-08-04 Meet C 20 2015-08-04 Meet D 10 2015-08-04 Training E 2 2015-08-04 Meet F 10 2015-08-04 Training A 30 2015-08-04 Meet B 20 2015-08-04 Do not take C 218 2015-08-04 Do not take D 3 2015-08-04 Meet E 10 2015-08-04 Training F 6 2015-08-04 Meet A 10 2015-08-04 Training B 7 2015-08-04 Meet C 20 2015-08-04 Do not take D 29 2015-08-04 Do not take E 48 2015-08-04 Training F 450 2015-08-04 Meet A 10 2015-08-04 Training B 15 2015-08-04 Meet C 25 2015-08-04 Training D 75 2015-08-04 Do not take E 26 2015-08-04 Meet F 20 2015-08-04 Do not take A 143 2015-08-04 Meet B 10 2015-08-04 Training C 20 2015-08-04 Meet D 10 2015-08-04 Training E 30 2015-08-04 Training F 480 2015-08-04 Training A 450 2015-08-04 Training B 45 2015-08-04 Meet C 10 2015-08-04 Meet D 40 2015-08-04 Meet E 10 2015-08-04 Training F 15 2015-08-04 Training A 60 2015-08-04 Training B 44 2015-08-04 Meet C 10 2015-08-04 Meet D 25 2015-08-04 Training E 75 2015-08-04 Training A 105 2015-08-04 Meet B 25 2015-08-04 Do not take C 38 2015-08-05 Do not take D 4 2015-08-05 Do not take E 7 2015-08-05 Do not take F 51 2015-08-05 Meet A 20 2015-08-05 Training B 75 2015-08-05 Do not take C 43 2015-08-05 Training D 450 2015-08-05 Do not take E 9 2015-08-05 Do not take F 50 2015-08-05 Training A 75 2015-08-05 Meet B 20 2015-08-05 Training C 15 2015-08-05 Training D 75 2015-08-05 Meet E 20 2015-08-05 Do not take F 52 2015-08-05 Training A 450 2015-08-05 Training B 450 2015-08-05 Training C 15 2015-08-05 Do not take D 51 2015-08-05 Do not take E 2 2015-08-05 Training F 77 2015-08-05 Training A 75 2015-08-05 Meet B 20 2015-08-05 Training C 480 2015-08-05 Training D 450 2015-08-05 Meet E 60 2015-08-05 Meet F 75 2015-08-05 Do not take A 4 2015-08-05 Do not take B 54 2015-08-05 Meet C 20 2015-08-05 Training D 95 2015-08-05 Training E 15 2015-08-05 Training F 8 2015-08-06 Do not take A 44 2015-08-06 Do not take B 2 2015-08-06 Do not take C 9 2015-08-06 Do not take D 39 2015-08-06 Training E 30 2015-08-06 Meet F 15 2015-08-06 Training A 8 2015-08-06 Do not take B 46 2015-08-06 Meet C 35 2015-08-06 Do not take D 42 2015-08-06 Do not take E 28 2015-08-06 Training F 20 2015-08-06 Training A 30 2015-08-06 Meet B 16 2015-08-06 Training C 30 2015-08-06 Training D 19 2015-08-06 Meet E 15 2015-08-06 Do not take F 54 2015-08-06 Do not take A 1 2015-08-06 Training B 180 2015-08-06 Training C 270 2015-08-06 Training D 35 2015-08-06 Training E 35 2015-08-06 Meet F 12 2015-08-06 Free A 4 2015-08-06 Training B 107 2015-08-06 Training C 24 2015-08-06 Do not take D 5 2015-08-06 Do not take E 43 2015-08-06 Meet F 35 2015-08-06 Training A 71 2015-08-06 Training B 30 2015-08-06 Meet C 16 2015-08-06 Meet D 35 2015-08-06 Training E 300 2015-08-06 Training F 180 2015-08-06 Training A 180 2015-08-06 Training B 270 2015-08-06 Training C 30 2015-08-06 Meet D 15 2015-08-06 Training E 70 2015-08-06 Meet F 35 2015-08-06 Training A 23 2015-08-06 Do not take B 26 2015-08-06 Do not take C 42 2015-08-06 Training D 15 2015-08-06 Training E 45 2015-08-06 Meet F 15 2015-08-06 Training A 30 2015-08-06 Meet B 6 2015-08-06 Training C 60 2015-08-06 Training D 86 2015-08-06 Meet E 6 2015-08-06 Do not take F 3 2015-08-07 Do not take A 130 2015-08-07 Meet B 4 2015-08-07 Do not take C 87 2015-08-07 Do not take D 10 2015-08-07 Do not take E 146 2015-08-07 Do not take F 7 2015-08-07 Meet A 4 2015-08-07 Do not take B 9 2015-08-07 Do not take C 160 2015-08-07 Meet D 4 2015-08-07 Meet E 60 2015-08-07 Training F 52 2015-08-07 Training A 55 2015-08-07 Training B 60 2015-08-07 Training C 450 2015-08-07 Do not take D 167 2015-08-07 Do not take E 13 2015-08-07 Meet F 4 2015-08-07 Training A 180 2015-08-07 Training B 270 2015-08-07 Free C 6 2015-08-07 Meet D 4 2015-08-07 Meet E 4 2015-08-07 Training F 60 2015-08-07 Training A 300 2015-08-07 Training B 180 2015-08-07 Training C 180 2015-08-07 Training D 270 2015-08-07 Training E 75 2015-08-07 Meet F 4 2015-08-07 Call A 60 2015-08-07 Meet B 4 2015-08-07 Free C 6 2015-08-07 Meet D 4 2015-08-10 Do not take E 221 2015-08-10 Do not take F 226 2015-08-10 Training A 150 2015-08-10 Meet B 10 2015-08-10 Do not take C 192 2015-08-10 Do not take D 1 2015-08-10 Meet E 4 2015-08-10 Meet F 10 2015-08-10 Free A 30 2015-08-10 Meet B 10 2015-08-10 Training C 15 2015-08-10 Meet D 4 2015-08-10 Do not take E 225 2015-08-10 Training F 90 2015-08-10 Training A 450 2015-08-10 Meet B 10 2015-08-10 Meet C 4 2015-08-10 Meet D 4 2015-08-10 Do not take E 1 2015-08-10 Do not take F 220 2015-08-10 Meet A 10 2015-08-10 Training B 15 2015-08-10 Training C 480 2015-08-10 Training D 150 2015-08-10 Training E 450 2015-08-10 Training F 10 2015-08-10 Training A 15 2015-08-10 Meet B 10 2015-08-10 Do not take C 5 2015-08-10 Do not take D 118 2015-08-10 Training E 15 2015-08-10 Meet F 10 2015-08-10 Meet A 4 2015-08-10 Free B 3 2015-08-10 Do not take C 223 2015-08-11 Do not take D 19 2015-08-11 Do not take E 51 2015-08-11 Meet F 90 2015-08-11 Training A 30 2015-08-11 Do not take B 188 2015-08-11 Do not take C 12 2015-08-11 Meet D 55 2015-08-11 Do not take E 5 2015-08-11 Do not take F 200 2015-08-11 Training A 30 2015-08-11 Training B 90 2015-08-11 Meet C 90 2015-08-11 Training D 30 2015-08-11 Training E 450 2015-08-11 Do not take F 39 2015-08-11 Do not take A 77 2015-08-11 Training B 450 2015-08-11 Meet C 55 2015-08-11 Training D 173 2015-08-11 Training E 0 2015-08-11 Do not take A 21 2015-08-11 Do not take B 89 2015-08-11 Meet C 25 2015-08-11 Training D 25 2015-08-11 Meet E 31 2015-08-11 Meet F 90 2015-08-11 Training A 30 2015-08-11 Training B 480 2015-08-11 Training C 150 2015-08-11 Training D 450 2015-08-11 Training E 150 2015-08-11 Training F 90 2015-08-11 Training A 30 2015-08-11 Meet B 55 2015-08-11 Meet C 25 2015-08-11 Do not take D 135 2015-08-11 Do not take E 11 2015-08-11 Meet F 10 2015-08-11 Training A 90 2015-08-11 Training B 45 2015-08-11 Meet C 30 2015-08-11 Training D 295 2015-08-11 Do not take E 222 2015-08-12 Do not take F 1 2015-08-12 Do not take A 173 2015-08-12 Training B 105 2015-08-12 Do not take C 13 2015-08-12 Do not take D 174 2015-08-12 Do not take E 235 2015-08-12 Do not take F 1 2015-08-12 Training A 105 2015-08-12 Training B 105 2015-08-12 Do not take C 172 2015-08-12 Do not take D 17 2015-08-12 Meet E 5 2015-08-12 Training F 60 2015-08-12 Do not take A 152 2015-08-12 Training B 90 2015-08-12 Training C 300 2015-08-12 Training D 150 2015-08-12 Meet E 90 2015-08-12 Training F 90 2015-08-12 Training A 60 2015-08-12 Meet B 5 2015-08-12 Training C 60 2015-08-12 Meet D 5 2015-08-12 Do not take E 176 2015-08-13 Do not take F 126 2015-08-13 Do not take A 12 2015-08-13 Do not take B 6 2015-08-13 Do not take C 210 2015-08-13 Do not take D 177 2015-08-13 Do not take E 8 2015-08-13 Training F 75 2015-08-13 Training A 75 2015-08-13 Meet B 30 2015-08-13 Do not take C 17 2015-08-13 Do not take D 140 2015-08-13 Training E 70 2015-08-13 Call F 60 2015-08-13 Training A 245 2015-08-13 Call B 60 2015-08-13 Training C 66 2015-08-13 Training D 150 2015-08-13 Training E 150 2015-08-13 Meet F 35 2015-08-13 Training A 45 2015-08-13 Training B 45 2015-08-13 Training C 82 2015-08-13 Training D 90 2015-08-14 Training E 450 2015-08-14 Free F 30 2015-08-14 Training A 95 2015-08-14 Meet B 15 2015-08-14 Training C 45 2015-08-14 Free D 30 2015-08-14 Training E 286 2015-08-14 Meet F 15 2015-08-14 Meet A 15 2015-08-14 Free B 30 2015-08-14 Training C 150 2015-08-14 Training D 150 2015-08-14 Meet E 15 2015-08-14 Free F 11 2015-08-14 Free A 16 2015-08-14 Training B 74 2015-08-14 Meet C 16 2015-08-14 Free D 22 2015-08-14 Training E 15 2015-08-16 Do not take F 26 2015-08-17 Do not take A 59 2015-08-17 Do not take B 52 2015-08-17 Do not take C 6 2015-08-17 Training D 90 2015-08-17 Training E 75 2015-08-17 Do not take F 30 2015-08-17 Do not take A 14 2015-08-17 Training B 60 2015-08-17 Do not take C 36 2015-08-17 Do not take D 85 2015-08-17 Training E 90 2015-08-17 Training F 75 2015-08-17 Training A 75 2015-08-17 Training B 90 2015-08-17 Do not take C 85 2015-08-17 Do not take D 33 2015-08-17 Training E 60 2015-08-17 Training F 90 2015-08-17 Do not take A 8 2015-08-17 Do not take B 57 2015-08-17 Training C 60 2015-08-17 Training D 75 2015-08-17 Meet E 90 2015-08-17 Training F 20 2015-08-17 Training A 60 2015-08-17 Do not take B 1 2015-08-17 Do not take C 1 2015-08-17 Meet D 90 2015-08-17 Meet E 75 2015-08-17 Training F 60 2015-08-17 Do not take A 14 2015-08-17 Do not take B 49 2015-08-17 Training C 90 2015-08-17 Training D 75 2015-08-17 Training E 90 2015-08-17 Meet F 165 2015-08-17 Meet A 5 2015-08-18 Do not take B 35 2015-08-18 Do not take C 15 2015-08-18 Do not take D 49 2015-08-18 Do not take E 21 2015-08-18 Meet F 5 2015-08-18 Training A 90 2015-08-18 Training B 60 2015-08-18 Meet C 5 2015-08-18 Do not take D 43 2015-08-18 Do not take E 5 2015-08-18 Training F 60 2015-08-18 Do not take A 46 2015-08-18 Do not take B 31 2015-08-18 Meet C 5 2015-08-18 Training D 60 2015-08-18 Training E 90 2015-08-18 Training F 45 2015-08-18 Training A 90 2015-08-18 Meet B 5 2015-08-18 Do not take C 46 2015-08-18 Do not take D 33 2015-08-18 Do not take E 2 2015-08-18 Do not take F 1 2015-08-18 Free A 30 2015-08-18 Training B 88 2015-08-18 Training C 150 2015-08-18 Meet D 5 2015-08-18 Training E 60 2015-08-18 Training F 145 2015-08-18 Training A 60 2015-08-18 Do not take B 1 2015-08-18 Do not take C 1 2015-08-18 Do not take D 2 2015-08-18 Training E 135 2015-08-18 Training F 88 2015-08-18 Training A 30 2015-08-18 Do not take B 1 2015-08-18 Do not take C 49 2015-08-18 Meet D 5 2015-08-18 Training E 45 2015-08-18 Training F 90 2015-08-18 Training A 105 2015-08-18 Meet B 5 2015-08-18 Training C 135 2015-08-18 Meet D 5 2015-08-18 Do not take E 7 2015-08-19 Do not take F 56 2015-08-19 Training A 45 2015-08-19 Do not take B 7 2015-08-19 Do not take C 46 2015-08-19 Do not take D 16 2015-08-19 Do not take E 51 2015-08-19 Training A 45 2015-08-19 Do not take B 12 2015-08-19 Do not take C 51 2015-08-19 Training D 30 2015-08-19 Training E 105 2015-08-19 Do not take F 15 2015-08-19 Do not take A 50 2015-08-19 Meet B 47 2015-08-19 Call C 30 2015-08-19 Do not take D 1 2015-08-19 Do not take E 2 2015-08-19 Training F 30 2015-08-19 Training A 0 2015-08-19 Do not take B 9 2015-08-19 Do not take C 55 2015-08-19 Training D 45 2015-08-19 Training E 105 2015-08-19 Training F 83 2015-08-19 Do not take A 6 2015-08-20 Do not take B 41 2015-08-20 Meet C 17 2015-08-20 Meet D 17 2015-08-20 Do not take E 2 2015-08-20 Do not take F 57 2015-08-20 Training A 60 2015-08-20 Do not take B 46 2015-08-20 Meet C 17 2015-08-20 Meet D 30 2015-08-20 Do not take E 2 2015-08-20 Do not take F 50 2015-08-20 Meet A 17 2015-08-20 Training B 60 2015-08-20 Meet C 17 2015-08-20 Do not take D 51 2015-08-20 Do not take E 4 2015-08-20 Do not take F 1 2015-08-20 Do not take A 1 2015-08-20 Do not take B 3 2015-08-20 Meet C 30 2015-08-20 Meet D 36 2015-08-20 Training E 91 2015-08-20 Do not take F 4 2015-08-20 Do not take A 56 2015-08-20 Meet B 17 2015-08-20 Meet C 30 2015-08-20 Training D 60 2015-08-20 Training E 60 2015-08-20 Meet F 30 2015-08-20 Do not take A 1 2015-08-20 Do not take B 1 2015-08-20 Do not take C 1 2015-08-20 Do not take D 1 2015-08-20 Do not take E 1 2015-08-20 Do not take F 1 2015-08-20 Free A 60 2015-08-20 Do not take B 1 2015-08-20 Do not take C 1 2015-08-20 Free D 30 2015-08-20 Training E 60 2015-08-20 Meet F 40 2015-08-20 Meet A 17 2015-08-20 Do not take B 2 2015-08-20 Do not take C 58 2015-08-20 Training D 60 2015-08-20 Training E 15 2015-08-20 Meet F 36 2015-08-20 Meet A 36 2015-08-20 Training B 57 2015-08-20 Meet C 36 2015-08-21 Do not take D 32 2015-08-21 Do not take E 5 2015-08-21 Meet F 36 2015-08-21 Free A 5 2015-08-21 Do not take B 46 2015-08-21 Do not take C 8 2015-08-21 Free D 90 2015-08-21 Meet E 36 2015-08-21 Do not take F 7 2015-08-21 Do not take A 40 2015-08-21 Meet B 36 2015-08-21 Free C 5 2015-08-21 Meet D 25 2015-08-21 Meet E 36 2015-08-21 Do not take F 8 2015-08-21 Do not take A 46 2015-08-21 Do not take B 19 2015-08-21 Meet C 36 2015-08-21 Do not take D 40 2015-08-21 Free E 5 2015-08-21 Meet F 30 2015-08-21 Do not take A 2 2015-08-21 Meet B 30 2015-08-21 Training C 60 2015-08-21 Meet D 25 2015-08-21 Training E 105 2015-08-21 Meet F 36 2015-08-21 Do not take A 12 2015-08-21 Do not take B 42 2015-08-21 Meet C 32 2015-08-21 Meet D 11 2015-08-21 Meet E 25 2015-08-21 Meet F 36 2015-08-21 Meet A 25 2015-08-21 Meet B 30 2015-08-21 Do not take C 2 2015-08-21 Training D 60 2015-08-21 Meet E 30 2015-08-21 Meet F 30 2015-08-21 Training A 60 2015-08-21 Meet B 30 2015-08-21 Do not take C 2 2015-08-21 Do not take D 49 2015-08-21 Meet E 25 2015-08-21 Free F 5 2015-08-21 Meet A 0 2015-08-21 Meet B 0 2015-08-21 Meet C 11 2015-08-21 Meet D 36 2015-08-21 Meet E 36 2015-08-21 Training F 30 2015-08-21 Do not take A 18 2015-08-24 Do not take B 39 2015-08-24 Free C 10 2015-08-24 Do not take D 56 2015-08-24 Do not take E 2 2015-08-24 Training F 85 2015-08-24 Training A 0 2015-08-24 Do not take B 48 2015-08-24 Do not take C 1 2015-08-24 Do not take D 51 2015-08-24 Do not take E 12 2015-08-24 Training F 85 2015-08-24 Training A 45 2015-08-24 Training B 0 2015-08-24 Training C 85 2015-08-24 Do not take D 54 2015-08-24 Training E 25 2015-08-24 Do not take F 1 2015-08-24 Meet A 5 2015-08-24 Training B 30 2015-08-24 Do not take C 10 2015-08-24 Do not take D 52 2015-08-24 Free E 12 2015-08-24 Training F 85 2015-08-24 Training A 45 2015-08-24 Training B 25 2015-08-24 Do not take C 1 2015-08-24 Do not take D 1 2015-08-24 Do not take E 1 2015-08-24 Training F 45 2015-08-24 Training A 85 2015-08-24 Training B 90 2015-08-24 Training C 40 2015-08-24 Training D 30 2015-08-24 Free E 20 2015-08-24 Meet F 5 2015-08-24 Meet A 5 2015-08-24 Free B 10 2015-08-24 Training C 30 2015-08-24 Do not take D 41 2015-08-25 Do not take E 7 2015-08-25 Do not take F 56 2015-08-25 Do not take A 1 2015-08-25 Training B 45 2015-08-25 Training C 70 2015-08-25 Do not take D 2 2015-08-25 Do not take E 48 2015-08-25 Free F 60 2015-08-25 Training A 60 2015-08-25 Do not take B 53 2015-08-25 Do not take C 3 2015-08-25 Training D 45 2015-08-25 Training E 70 2015-08-25 Training F 45 2015-08-25 Training A 70 2015-08-25 Do not take B 54 2015-08-25 Do not take C 2 2015-08-25 Do not take D 1 2015-08-25 Do not take E 3 2015-08-25 Do not take A 1 2015-08-25 Free B 60 2015-08-25 Training C 60 2015-08-25 Meet D 6 2015-08-25 Training E 60 2015-08-25 Do not take F 9 2015-08-25 Do not take A 58 2015-08-25 Free B 60 2015-08-25 Meet C 45 2015-08-25 Training D 70 2015-08-25 Training E 60 2015-08-25 Do not take F 1 2015-08-25 Do not take A 1 2015-08-25 Call B 90 2015-08-25 Training C 90 2015-08-25 Do not take D 1 2015-08-25 Do not take E 2 2015-08-25 Do not take F 1 2015-08-25 Do not take A 2 2015-08-25 Do not take B 1 2015-08-25 Training C 60 2015-08-25 Free D 64 2015-08-25 Free E 79 2015-08-25 Meet F 33 2015-08-26 Do not take A 41 2015-08-26 Do not take B 4 2015-08-26 Do not take C 52 2015-08-26 Meet D 33 2015-08-26 Training E 75 2015-08-26 Training F 45 2015-08-26 Free A 23 2015-08-26 Do not take B 46 2015-08-26 Meet C 33 2015-08-26 Do not take D 1 2015-08-26 Training E 75 2015-08-26 Training F 45 2015-08-26 Training A 75 2015-08-26 Training B 45 2015-08-26 Do not take C 50 2015-08-26 Do not take D 2 2015-08-26 Meet E 33 2015-08-26 Training F 75 2015-08-26 Do not take A 1 2015-08-26 Do not take B 1 2015-08-26 Training C 15 2015-08-26 Meet D 33 2015-08-26 Free E 24 2015-08-26 Do not take F 17 2015-08-26 Do not take A 1 2015-08-26 Meet B 33 2015-08-26 Training C 75 2015-08-26 Training D 45 2015-08-26 Call E 75 2015-08-26 Do not take F 3 2015-08-26 Do not take A 1 2015-08-26 Do not take B 2 2015-08-26 Training C 50 2015-08-26 Do not take D 1 2015-08-26 Do not take E 1 2015-08-26 Do not take F 1 2015-08-26 Do not take A 1 2015-08-26 Do not take B 4 2015-08-26 Do not take C 1 2015-08-26 Training D 75 2015-08-26 Training E 135 2015-08-26 Training F 60 2015-08-26 Meet A 33 2015-08-26 Meet B 15 2015-08-26 Meet C 33 2015-08-26 Meet D 33 2015-08-26 Training E 30 2015-08-26 Do not take F 38 2015-08-27 Do not take A 4 2015-08-27 Free B 70 2015-08-27 Free C 70 2015-08-27 Do not take D 43 2015-08-27 Do not take E 2 2015-08-27 Free F 55 2015-08-27 Do not take A 43 2015-08-27 Free B 70 2015-08-27 Free C 55 2015-08-27 Free D 55 2015-08-27 Training E 150 2015-08-27 Do not take F 5 2015-08-27 Free A 70 2015-08-27 Do not take B 43 2015-08-27 Meet C 5 2015-08-27 Training D 40 2015-08-27 Do not take E 1 2015-08-27 Do not take F 1 2015-08-27 Free A 55 2015-08-27 Training B 75 2015-08-27 Free C 55 2015-08-27 Free D 55 2015-08-27 Training E 450 2015-08-27 Free F 55 2015-08-27 Meet A 5 2015-08-27 Training B 100 2015-08-27 Free C 55 2015-08-27 Training D 40 2015-08-27 Do not take E 1 2015-08-27 Do not take F 1 2015-08-27 Do not take A 1 2015-08-27 Do not take B 2 2015-08-27 Do not take C 1 2015-08-27 Training D 40 2015-08-27 Training E 50 2015-08-27 Free F 55 2015-08-27 Meet A 5 2015-08-27 Free B 55 2015-08-27 Free C 55 2015-08-27 Free D 55 2015-08-27 Free E 55 2015-08-27 Free F 55 2015-08-27 Free A 55 2015-08-27 Do not take B 2 2015-08-28 Do not take C 37 2015-08-28 Meet D 15 2015-08-28 Free E 55 2015-08-28 Free F 55 2015-08-28 Training A 10 2015-08-28 Do not take B 41 2015-08-28 Do not take C 27 2015-08-28 Free D 90 2015-08-28 Training E 15 2015-08-28 Meet F 21 2015-08-28 Free A 55 2015-08-28 Do not take B 2 2015-08-28 Do not take C 45 2015-08-28 Free D 80 2015-08-28 Do not take E 32 2015-08-28 Do not take F 33 2015-08-28 Free A 90 2015-08-28 Training B 20 2015-08-28 Free C 90 2015-08-28 Training D 15 2015-08-28 Training E 300 2015-08-28 Do not take F 48 2015-08-28 Do not take A 4 2015-08-28 Free B 45 2015-08-28 Free C 20 2015-08-28 Meet D 8 2015-08-28 Meet E 5 2015-08-28 Do not take F 1 2015-08-28 Do not take A 1 2015-08-28 Free B 55 2015-08-28 Free C 80 2015-08-28 Free D 65 2015-08-28 Free E 55 2015-08-28 Training F 395 2015-08-28 Free A 90 2015-08-28 Free B 80 2015-08-28 Free C 80 2015-08-28 Free D 80 2015-08-28 Free E 55 2015-08-28 Meet F 5 2015-08-28 Training A 150 2015-08-28 Free B 55 2015-08-28 Do not take C 1 2015-08-28 Meet D 5 2015-08-28 Free E 80 2015-08-28 Free F 90 2015-08-28 Do not take A 27 2015-08-31 Do not take B 37 2015-08-31 Do not take C 37 2015-08-31 Do not take D 31 2015-08-31 Free E 55 2015-08-31 Do not take F 2 2015-08-31 Do not take A 49 2015-08-31 Free B 55 2015-08-31 Free C 55 2015-08-31 Free D 65 2015-08-31 Do not take E 3 2015-08-31 Do not take F 47 2015-08-31 Meet A 10 2015-08-31 Training B 70 2015-08-31 Free C 50 2015-08-31 Do not take D 1 2015-08-31 Do not take E 1 2015-08-31 Do not take A 1 2015-08-31 Do not take B 1 2015-08-31 Do not take C 1 2015-08-31 Do not take D 1 2015-08-31 Do not take E 2 2015-08-31 Do not take F 1 2015-08-31 Do not take A 1 2015-08-31 Free B 55 2015-08-31 Free C 55 2015-08-31 Free D 55 2015-08-31 Free E 55 2015-08-31 Free F 55 2015-08-31 Free A 55 2015-08-31 Training B 70 2015-08-31 Meet C 10 2015-08-31 Do not take D 1 2015-08-31 Do not take E 5 2015-08-31 Do not take F 1 2015-08-31 Do not take A 1 2015-08-31 Do not take B 7 2015-08-31 Do not take C 2 2015-08-31 Free D 50 2015-08-31 Do not take E 1 2015-08-31 Meet F 10 2015-08-31 Free A 50 2015-08-31 Training B 70 2015-08-31 Do not take C 1 2015-08-31 Free D 55 2015-08-31 Free E 55 2015-08-31 Free F 55 2015-08-31 Free A 55 2015-08-31 Free B 55 2015-08-31 <colgroup><col><col span="2"><col><col></colgroup><tbody> </tbody>

<colgroup><col><col span="4"><col><col span="6"><col><col span="6"><col><col span="6"><col><col span="5"></colgroup><tbody>
</tbody>

Can any one of you please help for this issue.

 

[JackDanIce]

There's too much information to make sense of what's going on, but I think you need SUMIF or SUMPRODUCT. SUMIF is faster, but I find SUMPRODUCT easier to apply after reading this link:
Excel SUMPRODUCT formula - Syntax, Usage, Examples and Tutorial | Chandoo.org - Learn Microsoft Excel Online

 

[Harry_1989]

Hi jack,
yea data is too much and even employees are also too much , i have tried Sum product but not getting solution to it, may be bcz of date but i am not sure, can please tell if possible

 

[AlanY]

try this, in B4 copy down and across

Excel 2012
	A	B	C	D	E	F	G	H	I	J
1	A	01-Aug	02-Aug	03-Aug	04-Aug	05-Aug	06-Aug	07-Aug	08-Aug	09-Aug
2	Total Working Time (Hrs)	510	510	510	510	510	510	510	510	510
3	Less: (-) Breaks
4	Call	0	0	0	0	0	0	60	0	0
5	Training	0	0	195	645	600	342	535	0	0
6	Free	0	0	18	0	0	4	0	0	0
7	Meet	0	0	30	20	20	0	4	0	0
8	Effective Time	510	510	267	-155	-110	164	-89	510	510
Sheet1

Cell Formulas
Range	Formula
B4	=SUMPRODUCT(Sheet2!$D$2:$D$1000,--(Sheet2!$A$2:$A$1000=Sheet1!$A4),--(Sheet2!$C$2:$C$1000=Sheet1!$A$1),--(Sheet2!$E$2:$E$1000=Sheet1!B$1))
B8	=B2-SUM(B4:B7)