Spreadsheet: 736765d1623851828-countif-a-and-b-are-both-present-table
Sheet: Raw Data (paste from Source)

Top 0 Employee Login | Top 0 Employment Type | Top 0 Shift Code | Top 0 Manager [NAME] | Top 0 Employee Start Date | Top 0 Learning Curve Family | Top 0 Learning Curve Level | Percent-to-Curve weighted by [NAME] | Sum of Hours Worked
suljameh | R | NA6-1845 | [NAME],[NAME] | 1606348800000 | Pick | Level 5 | 104.909658915128 | 90.6338849999999
suljameh | R | NA6-1845 | [NAME],[NAME] | 1606348800000 | [NAME] | Level 5 | 119.193687829969 | 61.3255552777777
suljameh | R | NA6-1845 | [NAME],[NAME] | 1606348800000 | Cycle Count | Level 4 | 132.096388785019 | 21.3941666666666
suljameh | R | NA6-1845 | [NAME],[NAME] | 1606348800000 | Cycle Count | Level 3 | 206.406026800897 | 4.28444444444444
suljameh | R | NA6-1845 | [NAME],[NAME] | 1606348800000 | [NAME] | Level 1 | 579.297144983784 | 0.746388888888888
suljameh | R | NA6-1845 | Strong,[NAME] | 1606348800000 | Pick | Level 5 | 107.558876795044 | 59.38972
suljameh | R | NA6-1845 | Strong,[NAME] | 1606348800000 | [NAME] | Level 5 | 74.1839020175257 | 18.9883333333333
suljameh | R | NA6-1845 | Strong,[NAME] | 1606348800000 | Cycle Count | Level 3 | 184.863173303554 | 33.7275
suljameh | R | NA6-1830 | [NAME],[NAME] | 1606348800000 | Pick | Level 5 | 99.2456180425363 | 61.6727758333333
suljameh | R | NA6-1830 | [NAME],[NAME] | 1606348800000 | [NAME] | Level 5 | 93.824781914214 | 60.7547216666666
suljameh | R | NA6-1830 | [NAME],[NAME] | 1606348800000 | Cycle Count | Level 4 | 167.903975169279 | 15.4752777777777
suljameh | R | NA6-1830 | [NAME],[NAME] | 1606348800000 | [NAME] | Level 1 | 623.376623376623 | 0.00611111111111111
kskaaru | R | RT678-4 | Metoyer,[NAME] | 1615161600000 | Pick | Level 5 | 117.768332552983 | 165.405270555555
kskaaru | R | RT678-4 | Metoyer,[NAME] | 1615161600000 | Pick | Level 2 | 112.822847216149 | 45.1194433333333
kskaaru | R | RT678-4 | Metoyer,[NAME] | 1615161600000 | Pick | Level 4 | 114.608205997131 | 44.1216647222222
kskaaru | R | RT678-4 | Metoyer,[NAME] | 1615161600000 | Pick | Level 3 | 119.396105152663 | 33.3758311111111
kskaaru | R | RT678-4 | Metoyer,[NAME] | 1615161600000 | [NAME] | Level 1 | 528.551198986966 | 1.35861055555555
kskaaru | R | RT678-4 | Espiritu,[NAME] | 1615161600000 | Pick | Level 5 | 103.671872470901 | 56.9402736111111
kskaaru | R | RT678-4 | Espiritu,[NAME] | 1615161600000 | [NAME] | Level 1 | 142.584787243085 | 27.0608333333333
kskaaru | R | RT678-4 | Espiritu,[NAME] | 1615161600000 | [NAME] | Level 1 | 236.27215051411 | 0.362777777777777
kskaaru | R | RT678-4 | Murrow,[NAME] | 1615161600000 | Pick | Level 5 | 110.72344122571 | 5.60861083333333
kskaaru | R | RT678-4 | Murrow,[NAME] | 1615161600000 | [NAME] | Level 1 | 153.238673478345 | 4.19944444444444
kskaaru | R | RT678-4 | Martinez,[NAME] | 1615161600000 | Pick | Level 5 | 122.562488646746 | 10.7380555555555
kskaaru | R | DA5-0730 | Murrow,[NAME] | 1615161600000 | Pick | Level 5 | 104.281517927484 | 77.1733294444444
kskaaru | R | DA5-0730 | Murrow,[NAME] | 1615161600000 | [NAME] | Level 1 | 112.088718386391 | 9.46805555555555
kskaaru | R | DA5-0730 | Murrow,[NAME] | 1615161600000 | [NAME] | Level 1 | 524.761360855021 | 0.486388888888888
kskaaru | R | DA5-0730 | Murrow,[NAME] | 1615161600000 | Pack | Level 1 | 129.939658607327 | 14.3372222222222
[NAME] | R | NA5-1845 | [NAME],[NAME] | 1608768000000 | Pick | Level 5 | 112.415043837282 | 238.268877777777
[NAME] | R | NA5-1845 | [NAME],[NAME] | 1608768000000 | [NAME] | Level 1 | 472.906403940886 | 0.0402777777777777
[NAME] | R | NA5-1845 | Holloway,[NAME] | 1608768000000 | Pick | Level 5 | 106.903032335795 | 82.20083
[NAME] | R | NA5-1845 | Holloway,[NAME] | 1608768000000 | [NAME] | Level 1 | 127.19396248924 | 35.6008333333333
[NAME] | R | NA5-1830 | Holloway,[NAME] | 1608768000000 | Pick | Level 5 | 103.100808179377 | 103.023329722222
[NAME] | R | NA5-1830 | Holloway,[NAME] | 1608768000000 | [NAME] | Level 2 | 121.725562544018 | 41.3591661111111
[NAME] | R | NA5-1830 | Holloway,[NAME] | 1608768000000 | [NAME] | Level 1 | 153.233883316438 | 4.99916666666666
[NAME] | R | NA5-1830 | Holloway,[NAME] | 1608768000000 | [NAME] | Level 1 | 530.285714285714 | 0.104166666666666
efraimac | R | NA7-1845 | [NAME],[NAME] | 1606348800000 | Pick | Level 4 | 121.800625170343 | 44.6408311111111