Spreadsheet: 60256d1260825949-excel-2007-count-multiple-cloumns-with-multiple-criteria-totals-count
Sheet: Sheet1

December 7th |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
Rack 1 |  | Rack 2 |  | Rack 3 |  | Rack 4 |  | Rack 5 |  | Rack 6 |  |  |  | WHITES | BRONZE | DAMAGED
White | [NAME] | White | [NAME] | White | [NAME] | White | [NAME] | White | [NAME] | White | [NAME] |  | Rack 1
5.4032 | 5.4208 | 5.896 | 5.016 | 4.5408 | 7.6208 | 4.276800000000001 | 5.2624 | 8.888 | 5.192 | 6.881600000000001 | 5.6144 |  | Rack 2
5.7904 | 6.0192 | 7.0928 | 8.0432 | 5.702400000000001 | 7.427199999999999 | 5.1568 | 7.814400000000001 | 10.2432 | 4.593599999999999 | 8.9936 | 5.5088 |  | Rack 3
5.4032 | 5.2448 | 7.4096 | 6.423999999999999 | 6.3888 | 8.342400000000001 | 4.5232 | 4.928 | 9.732800000000001 | 4.6288 | 9.2048 | 8.8528 |  | Rack 4
4.3648 | 5.016 | 5.104 | 6.3184 | 7.163200000000001 | 7.568 | 5.016 | 6.1248 | 8.606399999999999 | 5.5968 | 6.723199999999999 | 4.2592 |  | Rack 5
4.7696 | 4.8224 | 6.7936 | 6.1424 | 4.488 | 6.0544 | 4.84 | 5.2096 | 8.1488 | 4.9808 | 5.016 | 4.5584 |  | Rack 6
4.6288 | 6.1776 | 7.3216 | 6.6352 | 7.163200000000001 | 6.072 | 7.6736 | 4.6464 | 9.169599999999999 | 4.8048 | 7.9024 | 5.2624 |  | TOTAL
4.664 | 6.0896 | 7.3392 | 6.0896 | 4.6112 | 6.0192 | 4.5232 | 7.6736 | 7.3392 | 5.1216 | 5.2096 | 4.9984
4.8224 | 4.9104 | 6.4944 | 6.9344 | 4.8576 | 7.233600000000001 | 4.5232 | 5.544 | 4.664 | 4.6112 | 6.336 | 5.0336 |  | Day Total
4.1008 | 4.8752 | 6.5296 | 7.7616 | 4.8752 | 7.0048 | 6.8112 | 6.6704 | 7.6912 | 5.544 | 5.192 | 4.9808
8.4304 | 4.576000000000001 | 5.984 | 4.9456 | 5.808 | 6.6704 | 4.4704 | 5.6672 | 4.6112 | 5.984 | 6.8112 | 7.497599999999999 |  | Weight KG | White | [NAME]
4.0832 | 4.576000000000001 | 7.9728 | 8.7472 | 5.2096 | 4.928 | 5.4208 | 5.1216 | 4.664 | 4.8752 | 6.8288 | 6.2304 |  | 2.5
4.6992 | 5.1568 | 6.1248 | 5.8432 | 4.048 | 5.0336 | 4.5408 | 5.016 | 6.512 | 4.892799999999999 | 4.6816 | 4.7344 |  | 3
7.6912 | 4.8576 | 6.3712 | 5.5968 | 5.8256 | 6.1248 | 6.0368 | 4.84 | 5.456 | 5.1744 | 6.512 | 4.3648 |  | 3.5
5.3504 | 4.9104 | 7.568 | 6.2304 | 4.5408 | 5.6848 | 4.7168 | 5.5616 | 4.4352 | 4.892799999999999 | 4.8224 | 5.2448 |  | 4
4.5584 | 5.7552 | 6.3536 | 5.297599999999999 | 4.892799999999999 | 5.1392 | 4.2416 | 5.192 | 5.5792 | 4.8224 | 4.6992 | 9.24 |  | 4.5
4.7168 | 5.1392 | 5.9488 | 6.072 | 4.7872 | 7.444800000000001 | 3.9776 | 4.892799999999999 | 5.5616 | 5.1568 | 7.7616 | 6.512 |  | 5
4.1888 | 7.0928 | 4.8576 | 8.36 | 4.593599999999999 | 5.28 | 6.2656 | 4.9984 | 4.488 | 4.928 | 4.928 | 4.6992 |  | 5.5
5.2096 | 5.7552 | 6.3712 | 6.582400000000001 | 6.1248 | 7.0048 | 6.4416 | 4.6992 | 7.6736 | 4.8224 | 4.6816 | 5.456 |  | 6
4.417599999999999 | 4.8576 | 7.7088 | 5.9488 | 4.6288 | 5.9312 | 4.6112 | 5.2096 | 4.5232 | 5.1744 | 4.593599999999999 | 5.5088 |  | 6.5
4.6816 | 4.9808 | 6.072 | 5.8784 | 6.5472 | 4.9808 | 4.4352 | 6.2128 | 6.6352 | 5.28 | 5.1216 | 6.0896 |  | 7
4.6112 | 5.0336 | 5.6496 | 6.3712 | 4.892799999999999 | 6.336 | 5.8784 | 5.9664 | 6.406400000000001 | 4.8576 | 4.6112 | 8.9936 |  | 7.5
7.163200000000001 | 5.0336 | 4.8048 | 5.1216 | 8.5008 | 5.632000000000001 | 4.892799999999999 | 5.8432 | 5.051200000000001 | 5.1216 | 4.3648 | 4.5056 |  | 8
4.576000000000001 | 5.72 | 6.0896 | 6.247999999999999 | 6.5648 | 4.7344 | 6.1424 | 5.1392 | 4.8576 | 4.9456 | 5.3152 | 5.5088 |  | 8.5
5.1216 | 4.6816 | 6.0544 | 6.2656 | 5.632000000000001 | 6.723199999999999 | 4.6464 | 5.5088 | 7.128 | 5.2624 | 4.9632 | 5.526400000000001 |  | 9
4.6112 | 5.051200000000001 | 6.2304 | 6.512 | 5.4384 | 5.9312 | 4.488 | 4.892799999999999 | 4.84 | 5.5792 | 7.656 | 4.7696 |  | 9.5
5.4384 | 5.5616 | 6.247999999999999 | 6.300800000000001 | 7.6208 | 6.1952 | 5.1392 | 5.297599999999999 | 4.84 | 5.1392 | 6.6352 | 7.392 |  | 10
5.544 | 4.593599999999999 | 5.8608 | 6.3536 | 4.6992 | 4.9632 | 4.276800000000001 | 5.3504 | 7.3568 | 5.28 | 5.6144 | 4.9984 |  | 10.5
5.0864 | 4.312 | 5.9136 | 5.9664 | 7.163200000000001 | 4.84 | 5.3504 | 6.300800000000001 | 6.3888 | 4.892799999999999 | 6.8992 | 5.5792 |  | 11
7.603200000000001 | 6.3536 | 6.6352 | 4.6992 | 6.776 | 4.8048 | 4.1008 | 4.382400000000001 | 7.163200000000001 | 4.8752 | 5.1568 | 4.9808 |  | 11.5
4.0832 | 5.3152 | 5.1568 | 11.176 | 8.0432 | 7.48 | 6.1424 | 4.9456 | 7.180800000000001 | 5.9312 | 7.5504 | 7.2864 |  | 12
5.0336 | 4.5056 | 6.4416 | 6.476800000000001 | 11 | 6.2304 | 4.5408 | 6.423999999999999 | 5.6848 | 5.1744 | 4.576000000000001 | 4.8224 |  | 12.5
7.6208 | 5.227200000000001 | 5.4384 | 5.297599999999999 | 5.1744 | 6.2128 | 4.8576 | 5.6848 | 5.473599999999999 | 5.28 | 4.417599999999999 | 4.2592 |  | 13
4.118399999999999 | 4.84 | 7.5328 | 6.0368 | 6.8992 | 5.456 | 5.4912 | 5.1568 | 4.892799999999999 | 5.104 | 5.72 | 5.702400000000001 |  | 13.5
5.4032 | 4.6464 | 5.7728 | 5.3152 | 6.5648 | 5.6496 | 5.0864 | 4.7872 | 6.0016 | 4.9104 | 5.1216 | 6.7408 |  | 14
6.2128 | 5.1216 | 5.896 | 6.2304 | 5.984 | 5.104 | 6.0016 | 4.417599999999999 | 4.6464 | 5.297599999999999 | 4.1888 | 4.928 |  | 14.5
4.892799999999999 | 4.9632 | 5.5616 | 6.336 | 6.406400000000001 | 6.0192 | 4.892799999999999 | 4.7344 | 7.7616 | 5.5088 | 4.9456 | 4.576000000000001 |  | 15
4.2592 | 4.9984 | 5.1216 | 6.336 | 7.3216 | 6.3888 | 6.7056 | 5.227200000000001 | 5.2096 | 5.984 | 4.6992 | 10.12 |  | 15.5
4.84 | 5.6496 | 6.9168 | 6.0016 | 5.632000000000001 | 5.5792 | 4.6816 | 5.016 | 5.3856 | 6.0368 | 5.016 | 4.312 |  | 16
4.2592 | 5.0336 | 7.0224 | 6.582400000000001 | 10.3136 | 4.593599999999999 | 4.4 | 4.752000000000001 | 4.593599999999999 | 6.3712 | 5.702400000000001 | 4.4352
7.427199999999999 | 4.3296 | 4.9456 | 5.702400000000001 | 6.582400000000001 | 6.3712 | 6.4944 | 4.928 | 4.5584 | 5.526400000000001 | 5.72 | 4.576000000000001
4.488 | 5.104 | 6.4592 |  | 5.526400000000001 | 9.944 | 5.28 | 5.192 | 4.892799999999999 | 4.892799999999999 | 5.297599999999999 | 6.1952
5.702400000000001 | 5.1392 | 6.0544 |  | 7.7088 | 7.215999999999999 | 5.1392 | 5.456 | 5.5968 | 7.9728 | 5.9488 | 5.5616
6.0016 | 4.752000000000001 | 4.928 |  | 5.456 | 8.3776 | 6.723199999999999 | 4.8048 | 5.0688 | 4.84 | 5.7376 | 4.9808
4.224 | 6.2656 | 6.3184 |  | 7.304 | 6.1952 | 13.1648 | 4.3648 | 6.5472 | 4.752000000000001 | 4.4352 | 7.427199999999999
7.075199999999999 | 6.423999999999999 | 5.896 |  | 7.48 | 9.2928 | 5.2624 | 4.5232 | 5.0336 | 4.5584 | 5.2624 | 7.462400000000001
5.896 | 5.192 | 6.0016 |  | 5.227200000000001 | 6.2304 | 5.0336 | 4.8576 | 4.3648 | 5.544 | 4.2592 | 4.7872
5.4384 | 4.84 | 6.406400000000001 |  | 5.984 |  | 7.6384 | 4.6112 | 5.297599999999999 | 5.104 | 4.4528 | 6.7584
7.163200000000001 | 5.0688 | 5.28 |  | 8.6416 |  | 6.0016 | 4.9984 | 6.6528 | 6.2304 | 6.5648 | 7.9728
4.752000000000001 | 4.2416 | 7.392 |  | 6.0016 |  | 6.6528 | 5.1392 | 4.417599999999999 | 4.6816 | 5.3504 | 5.4032
5.0864 | 5.3152 | 7.7264 |  | 5.808 |  | 4.576000000000001 | 5.4912 | 4.892799999999999 | 6.7056 | 4.4 | 4.9456
4.9456 | 5.4208 | 6.881600000000001 |  | 5.3152 |  | 5.8784 | 4.928 | 6.0368 | 5.3328 | 7.515199999999999 | 5.5792
5.5088 | 5.3152 | 6.6704 |  | 6.336 |  | 4.8048 | 4.752000000000001 | 8.025599999999999 | 4.8752 | 6.6704 | 5.3328
4.7696 | 5.1216 | 6.8992 |  | 6.776 |  | 4.8752 |  | 4.8752 | 6.4944 | 4.9456 | 5.2448
4.7344 | 4.6288 | 6.688 |  | 6.406400000000001 |  | 7.3568 |  | 7.0576 | 5.808 | 6.5648 | 5.6672
4.8752 | 4.7344 | 5.72 |  | 4.7872 |  | 4.6992 |  | 4.4352 | 4.6992 | 6.8288 | 6.0544
4.8224 | 5.4384 | 6.1952 |  | 4.9104 |  | 4.3296 |  | 4.3648 | 4.9104 | 6.5648 | 5.1568
4.5056 | 7.1104 | 6.2128 |  | 6.300800000000001 |  | 6.1248 |  | 4.7872 | 5.896 | 4.5056 | 5.1216
4.4704 | 5.7552 | 6.2656 |  | 4.9808 |  | 8.008 |  | 7.2864 | 4.5232 | 7.233600000000001 | 5.0336
7.2864 | 4.7872 | 6.0192 |  | 7.568 |  | 5.6144 |  | 4.8576 | 4.6816 | 4.2944 | 4.8048
5.297599999999999 | 5.5088 | 5.4384 |  | 4.9632 |  | 6.5472 |  | 6.4416 | 4.928 | 5.526400000000001 | 5.7376
4.7344 | 4.752000000000001 | 5.808 |  | 4.752000000000001 |  | 4.6112 |  | 5.051200000000001 | 5.0336 | 6.0368 | 5.297599999999999
4.4 | 6.406400000000001 | 7.7264 |  | 5.3856 |  | 5.7728 |  | 4.4704 | 4.892799999999999 | 6.0896 | 5.3152
4.347200000000001 | 6.952 | 6.1952 |  | 7.5504 |  | 4.8752 |  | 4.382400000000001 | 4.6464 | 7.7264 | 8.27
5.2096 | 5.4032 | 5.702400000000001 |  | 5.5968 |  | 5.367999999999999 |  | 6.776 | 4.6816 | 7.9904 | 8.08
6.476800000000001 | 4.928 | 7.3568 |  | 4.6992 |  | 4.382400000000001 |  | 6.2656 | 4.9984 | 7.92 | 9.36
6.1776 | 4.7344 | 6.3888 |  | 7.128 |  | 5.3152 |  | 7.6384 | 7.0048 | 5.2448 | 8.73
4.7344 | 5.0688 | 5.9136 |  | 7.374400000000001 |  | 4.224 |  | 5.5968 | 6.2832 | 5.297599999999999 | 5
5.473599999999999 |  | 7.4096 |  | 6.3184 |  | 4.118399999999999 |  | 4.752000000000001 | 5.0864 | 5.632000000000001 | 7.59
6.7056 |  | 7.2688 |  | 7.6736 |  | 4.4704 |  | 6.6704 | 6.423999999999999 | 4.4704 | 4.51
4.6112 |  | 5.3856 |  | 6.6 |  | 4.4704 |  | 8.3072 | 6.406400000000001 | 4.9456 | 4.95
5.5616 |  | 3.52 |  | 5.984 |  | 5.297599999999999 |  | 4.6816 | 4.7168 | 4.6112 | 4.77
4.7872 |  | 5.2624 |  | 5.227200000000001 |  | 4.6464 |  | 8.7824 | 6.0192 | 5.0336 | 4.54
4.7872 |  | 5.8784 |  | 6.0896 |  | 3.0272 |  | 6.0368 | 7.9552 | 4.2064 | 4.77
4.6464 |  | 5.5792 |  | 5.3328 |  | 4.5584 |  | 9.4512 | 7.9376 | 4.4704
5.6672 |  | 6.8112 |  | 5.3328 |  | 5.6672 |  | 4.2592 | 6.5472 | 4.9984
5.4384 |  | 8.184000000000001 |  | 7.497599999999999 |  | 4.6288 |  | 4.2944 |  | 5.6496
4.6288 |  | 6.6 |  | 6.0368 |  | 6.952 |  | 4.4352 |  | 6.4944
4.752000000000001 |  | 5.104 |  | 6.2128 |  | 5.3856 |  | 6.3712 |  | 7.7088
4.0832 |  | 7.1104 |  | 6.16 |  | 5.297599999999999 |  | 4.8048 |  | 4.576000000000001
4.7344 |  | 5.7728 |  | 6.3888 |  | 7.515199999999999 |  | 5.72 |  | 4.3296
4.488 |  | 6.8992 |  | 6.776 |  | 5.4032 |  | 5.544 |  | 7.304
4.8048 |  | 6.476800000000001 |  | 6.6352 |  | 4.7344 |  | 4.224 |  | 5.104
4.6992 |  | 5.9312 |  | 5.9136 |  | 4.4352 |  | 7.515199999999999 |  | 4.7168
4.417599999999999 |  | 6.0192 |  | 7.603200000000001 |  | 5.4384 |  | 4.6288 |  | 4.664
6.1248 |  | 6.423999999999999 |  | 5.8784 |  | 7.779199999999999 |  | 4.382400000000001 |  | 7.6384
5.1568 |  | 5.456 |  | 6.107200000000001 |  | 7.779199999999999 |  | 4.224 |  | 6.776
4.8752 |  | 7.444800000000001 |  | 7.215999999999999 |  | 5.9488 |  | 6.1424 |  | 4.7872
6.107200000000001 |  | 6.2656 |  | 5.2096 |  | 4.6112 |  | 4.4704 |  | 4.54
 |  | 6.8464 |  | 6.1424 |  | 4.0304 |  | 4.892799999999999 |  | 5.53
 |  | 7.656 |  | 6.4592 |  | 6.16 |  | 4.7696 |  | 8.61
 |  | 6.512 |  | 6.881600000000001 |  | 4.5584 |  | 6.6352 |  | 7.55
 |  | 6.0192 |  | 5.544 |  | 3.9424 |  | 4.84 |  | 5.47
 |  | 5.28 |  | 3.3968 |  | 7.304 |  | 5.7376 |  | 4.49
 |  | 7.497599999999999 |  | 6.0896 |  | 5.6848 |  | 4.6992 |  | 4.26
 |  | 6.881600000000001 |  | 5.7552 |  | 7.2864 |  | 5.1744 |  | 6.49
 |  | 6.0544 |  | 7.9552 |  | 7.0928 |  |  |  | 5.49
 |  | 8.1664 |  | 7.9904 |  | 5.3504 |  |  |  | 4.89
 |  | 6.864 |  | 5.544 |  | 4.6816 |  |  |  | 8.29
 |  | 8.342400000000001 |  | 5.6672 |  | 5.297599999999999 |  |  |  | 9.15
 |  | 6.512 |  | 4.9808 |  | 4.1008 |  |  |  | 7.06
 |  | 6.5648 |  | 8.0432 |  | 5.6496
 |  | 6.1952 |  | 6.7056 |  | 4.7696
 |  | 5.9136 |  | 6.4416 |  | 6.247999999999999
 |  | 6.7056 |  | 6.6528 |  | 4.928
 |  | 6.336 |  | 7.9024 |  | 4.382400000000001
 |  | 7.568 |  | 8.1136 |  | 4.7168
 |  | 6.6 |  | 7.6736 |  | 4.8224
 |  | 5.984 |  | 5.9488 |  | 4.171200000000001
 |  | 6.8112 |  | 8.324800000000002 |  | 6.107200000000001
 |  | 5.051200000000001 |  | 7.233600000000001 |  | 4.5408
 |  | 7.8672 |  | 6.0368 |  | 5.1744
 |  | 6.3888 |  | 6.8288 |  | 4.6112
 |  | 6.2304 |  | 5.5968 |  | 5.104
 |  | 5.808 |  | 6.4944 |  | 6.3712
 |  | 6.3712 |  | 5.4208 |  | 8.0784
 |  | 7.145599999999999 |  | 6.617599999999999 |  | 6.2128
 |  | 5.4384 |  | 7.744000000000001 |  | 9.3104
 |  | 6.1424 |  | 6.8992
 |  | 5.473599999999999 |  | 7.7088
 |  | 4.9104 |  | 7.656
 |  | 8.342400000000001 |  | 6.5648
 |  | 6.476800000000001 |  | 7.8496
 |  | 5.051200000000001 |  | 5.7552
 |  | 5.7552 |  | 8.0608
 |  | 6.0368 |  | 7.0576
 |  | 6.688 |  | 5.473599999999999
 |  | 7.7264 |  | 7.6384
 |  | 6.723199999999999 |  | 7.3568
 |  | 6.3184 |  | 6.864
 |  | 6.2832
 |  | 8.342400000000001
 |  | 6.4944
 |  | 4.7696
 |  | 5.8608
 |  | 7.2688