Spreadsheet: 214912d1361186446-need-to-sum-multiple-values-based-on-match-test
Sheet: Sal - Weekly

EE ID | Name | Department | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24
678790 | Emp 1 | Finance | 2047.269439421338 | 2047.269439 | 2047.269439 | 2047.269439 | 2047.269439 | 2047.269439 | 2047.269439 | 2047.269439 | 2047.269439 | 2047.269439 | 2047.269439 | 2047.269439
548824 | Emp 2 | Finance | 1744.984930681133 | 1744.984931 | 1744.984931 | 1744.984931 | 1744.984931 | 1744.984931 | 1744.984931 | 1744.984931 | 1744.984931 | 1744.984931 | 1744.984931 | 1744.984931
528036 | Emp 3 | Finance | 2612.46835443038 | 2612.468354 | 2612.468354 | 2612.468354 | 2612.468354 | 2612.468354 | 2612.468354 | 2612.468354 | 2612.468354 | 2612.468354 | 2612.468354 | 2612.468354
675250 | Emp 4 | Finance | 1077.157926461724 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926
574304 | Emp 5 | [NAME] | 1077.157926461724 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926 | 1077.157926
409569 | Emp 6 | [NAME] | 552.2061482820977 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483
2121 | Emp 7 | [NAME] | 764.8869801084992 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801
324123 | Emp 8 | [NAME] | 1924.671488848704 | 1924.671489 | 1924.671489 | 1924.671489 | 1924.671489 | 1924.671489 | 1924.671489 | 1924.671489 | 1924.671489 | 1924.671489 | 1924.671489 | 1924.671489
713515 | Emp 9 | [NAME] | 1567.807414104883 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414
1642412 | Emp 10 | [NAME] Manager | 2561.66968053044 | 2561.669681 | 2561.669681 | 2561.669681 | 2561.669681 | 2561.669681 | 2561.669681 | 2561.669681 | 2561.669681 | 2561.669681 | 2561.669681 | 2561.669681
257838 | Emp 11 | [NAME] Manager | 2983.713080168777 | 2983.71308 | 2983.71308 | 2983.71308 | 2983.71308 | 2983.71308 | 2983.71308 | 2983.71308 | 2983.71308 | 2983.71308 | 2983.71308 | 2983.71308
816018 | Emp 12 | [NAME] Manager | 3527.180530440025 | 3527.18053 | 3527.18053 | 3527.18053 | 3527.18053 | 3527.18053 | 3527.18053 | 3527.18053 | 3527.18053 | 3527.18053 | 3527.18053 | 3527.18053
288470 | Emp 13 | [NAME] Manager | 1309.653405666064 | 1309.653406 | 1309.653406 | 1309.653406 | 1309.653406 | 1309.653406 | 1309.653406 | 1309.653406 | 1309.653406 | 1309.653406 | 1309.653406 | 1309.653406
716285 | Emp 14 | [NAME] Manager | 1441.222121760096 | 1441.222122 | 1441.222122 | 1441.222122 | 1441.222122 | 1441.222122 | 1441.222122 | 1441.222122 | 1441.222122 | 1441.222122 | 1441.222122 | 1441.222122
864666 | Emp 15 | HTML | 1657.03285111513 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851
3294676 | Emp 16 | HTML | 552.2061482820977 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483 | 552.2061483
540968 | Emp 17 | HTML | 764.8869801084992 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801
401547 | Emp 18 | HTML | 1121.752561784207 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562
555012 | Emp 19 | HTML | 783.8351416515974 | 783.8351417 | 783.8351417 | 783.8351417 | 783.8351417 | 783.8351417 | 783.8351417 | 783.8351417 | 783.8351417 | 783.8351417 | 783.8351417 | 783.8351417
710420 | Emp 20 | HTML | 1916.232670283303 | 1916.23267 | 1916.23267 | 1916.23267 | 1916.23267 | 1916.23267 | 1916.23267 | 1916.23267 | 1916.23267 | 1916.23267 | 1916.23267 | 1916.23267
710425 | Emp 21 | HTML | 1032.52712477396 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125
575892 | Emp 22 | HTML | 1447.792344786016 | 1447.792345 | 1447.792345 | 1447.792345 | 1447.792345 | 1447.792345 | 1447.792345 | 1447.792345 | 1447.792345 | 1447.792345 | 1447.792345 | 1447.792345
577344 | Emp 23 | HTML | 1300.167269439421 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269
677315 | Emp 24 | HTML | 764.8869801084992 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801
282560 | Emp 25 | HTML | 764.8869801084992 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801 | 764.8869801
720810 | Emp 26 | HTML | 3161.309523809524 | 3161.309524 | 3161.309524 | 3161.309524 | 3161.309524 | 3161.309524 | 3161.309524 | 3161.309524 | 3161.309524 | 3161.309524 | 3161.309524 | 3161.309524
705890 | Emp 27 | HTML | 1657.03285111513 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851 | 1657.032851
722595 | Emp 28 | HTML | 1389.392706449669 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706
433890 | Emp 29 | HTML | 3398.494575045208 | 3398.494575 | 3398.494575 | 3398.494575 | 3398.494575 | 3398.494575 | 3398.494575 | 3398.494575 | 3398.494575 | 3398.494575 | 3398.494575 | 3398.494575
542248 | Emp 30 | HTML | 1507.320675105485 | 1507.320675 | 1507.320675 | 1507.320675 | 1507.320675 | 1507.320675 | 1507.320675 | 1507.320675 | 1507.320675 | 1507.320675 | 1507.320675 | 1507.320675
379932 | Emp 31 | HTML | 1121.752561784207 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562 | 1121.752562
288376 | Emp 32 | HTML | 2468.682941531043 | 2468.682942 | 2468.682942 | 2468.682942 | 2468.682942 | 2468.682942 | 2468.682942 | 2468.682942 | 2468.682942 | 2468.682942 | 2468.682942 | 2468.682942
4947888 | Emp 33 | [NAME] | 1300.167269439421 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269 | 1300.167269
2476098 | Emp 34 | [NAME] | 1032.52712477396 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125 | 1032.527125
859668 | Emp 35 | [NAME] | 1255.572634116938 | 1255.572634 | 1255.572634 | 1255.572634 | 1255.572634 | 1255.572634 | 1255.572634 | 1255.572634 | 1255.572634 | 1255.572634 | 1255.572634 | 1255.572634
571788 | Emp 36 | [NAME] | 1478.618143459916 | 1478.618143 | 1478.618143 | 1478.618143 | 1478.618143 | 1478.618143 | 1478.618143 | 1478.618143 | 1478.618143 | 1478.618143 | 1478.618143 | 1478.618143
1634910 | Emp 37 | [NAME] | 1567.807414104883 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414 | 1567.807414
3281200 | Emp 38 | [NAME] | 987.9324894514768 | 987.9324895 | 987.9324895 | 987.9324895 | 987.9324895 | 987.9324895 | 987.9324895 | 987.9324895 | 987.9324895 | 987.9324895 | 987.9324895 | 987.9324895
431922 | Emp 39 | [NAME] | 961.1693791440626 | 961.1693791 | 961.1693791 | 961.1693791 | 961.1693791 | 961.1693791 | 961.1693791 | 961.1693791 | 961.1693791 | 961.1693791 | 961.1693791 | 961.1693791
781776 | Emp 40 | [NAME] | 5469.077757685352 | 5469.077758 | 5469.077758 | 5469.077758 | 5469.077758 | 5469.077758 | 5469.077758 | 5469.077758 | 5469.077758 | 5469.077758 | 5469.077758 | 5469.077758
273980 | Emp 41 | [NAME] | 4979.159132007234 | 4979.159132 | 4979.159132 | 4979.159132 | 4979.159132 | 4979.159132 | 4979.159132 | 4979.159132 | 4979.159132 | 4979.159132 | 4979.159132 | 4979.159132
432783 | Emp 42 | [NAME] | 5630.028631705847 | 5630.028632 | 5630.028632 | 5630.028632 | 5630.028632 | 5630.028632 | 5630.028632 | 5630.028632 | 5630.028632 | 5630.028632 | 5630.028632 | 5630.028632
260696 | Emp 43 | [NAME] | 5802.946051838458 | 5802.946052 | 5802.946052 | 5802.946052 | 5802.946052 | 5802.946052 | 5802.946052 | 5802.946052 | 5802.946052 | 5802.946052 | 5802.946052 | 5802.946052
433134 | Emp 44 | [NAME] | 10836.93640747438 | 10836.93641 | 10836.93641 | 10836.93641 | 10836.93641 | 10836.93641 | 10836.93641 | 10836.93641 | 10836.93641 | 10836.93641 | 10836.93641 | 10836.93641
87686 | Emp 45 | [NAME] | 1228.808016877637 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017
430731 | Emp 46 | [NAME] | 1003.160036166365 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036
1640808 | Emp 47 | [NAME] | 1367.188065099458 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065
431715 | Emp 48 | [NAME] | 508.5880048221821 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048
287302 | Emp 49 | [NAME] | 492.9279686558168 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687
4102025 | Emp 50 | [NAME] | 1227.86769138035 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691
602505 | Emp 51 | [NAME] | 1025.420433996384 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434
719540 | Emp 52 | [NAME] | 1389.392706449669 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706
5008890 | Emp 53 | [NAME] | 666.7646172393008 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172
720865 | Emp 54 | [NAME] | 704.6157323688969 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324
433146 | Emp 55 | [NAME] | 622.9505726341171 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726
574724 | Emp 56 | [NAME] | 1194.688065099458 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065
283374 | Emp 57 | [NAME] | 663.7823990355636 | 663.782399 | 663.782399 | 663.782399 | 663.782399 | 663.782399 | 663.782399 | 663.782399 | 663.782399 | 663.782399 | 663.782399 | 663.782399
430797 | Emp 58 | [NAME] | 867.9852320675107 | 867.9852321 | 867.9852321 | 867.9852321 | 867.9852321 | 867.9852321 | 867.9852321 | 867.9852321 | 867.9852321 | 867.9852321 | 867.9852321 | 867.9852321
575040 | Emp 59 | [NAME] | 786.3004822182037 | 786.3004822 | 786.3004822 | 786.3004822 | 786.3004822 | 786.3004822 | 786.3004822 | 786.3004822 | 786.3004822 | 786.3004822 | 786.3004822 | 786.3004822
765769 | Emp 60 | [NAME] | 949.6518987341773 | 949.6518987 | 949.6518987 | 949.6518987 | 949.6518987 | 949.6518987 | 949.6518987 | 949.6518987 | 949.6518987 | 949.6518987 | 949.6518987 | 949.6518987
4141585 | Emp 61 | [NAME] | 554.3399638336348 | 554.3399638 | 554.3399638 | 554.3399638 | 554.3399638 | 554.3399638 | 554.3399638 | 554.3399638 | 554.3399638 | 554.3399638 | 554.3399638 | 554.3399638
123214 | Emp 62 | [NAME] | 1228.808016877637 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017 | 1228.808017
288104 | Emp 63 | [NAME] | 1003.160036166365 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036 | 1003.160036
718400 | Emp 64 | [NAME] | 1367.188065099458 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065 | 1367.188065
693380 | Emp 65 | [NAME] | 508.5880048221821 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048 | 508.5880048
89876 | Emp 66 | [NAME] | 492.9279686558168 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687 | 492.9279687
716325 | Emp 67 | Product Manager | 1227.86769138035 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691 | 1227.867691
12321 | Emp 68 | Product Manager | 1025.420433996384 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434 | 1025.420434
12145 | Emp 69 | Product Manager | 1389.392706449669 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706 | 1389.392706
124908 | Emp 70 | Product Manager | 666.7646172393008 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172 | 666.7646172
288674 | Emp 71 | Product Manager | 704.6157323688969 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324 | 704.6157324
408198 | Emp 72 | Marketing | 622.9505726341171 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726 | 622.9505726
713885 | Emp 73 | Marketing | 1194.688065099458 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065 | 1194.688065