Spreadsheet: 819664d1677623371-sumif-formula-matching-similar-text-and-how-to-distinguish-between-them-sumif-with-bru_br
Sheet: Sheet1

 |  | 1-Feb | 2-Feb | 3-Feb | 4-Feb | 5-Feb | 6-Feb | 7-Feb | 8-Feb | 9-Feb | 10-Feb | 11-Feb | 12-Feb | 13-Feb | 14-Feb | 15-Feb | 16-Feb | 17-Feb | 18-Feb | 19-Feb | 20-Feb | 21-Feb | 22-Feb | 23-Feb | 24-Feb | 25-Feb | 26-Feb
 | ON
 | TS
 | THO
 | BRU
 | BR
 | BC
 | JE
 | MN
 | Unlisted
 | Material Code
 | Sum of Mass
 | Row Labels | 1-Feb | 2-Feb | 3-Feb | 4-Feb | 5-Feb | 6-Feb | 7-Feb | 8-Feb | 9-Feb | 10-Feb | 11-Feb | 12-Feb | 13-Feb | 14-Feb | 15-Feb | 16-Feb | 17-Feb | 18-Feb | 19-Feb | 20-Feb | 21-Feb | 22-Feb | 23-Feb | 24-Feb | 25-Feb | 26-Feb
 | EX125 | 14679 | 20886 | 9204 | 19101 | 1298 | 14827.1 | 2478 | 1180 |  |  |  |  |  | 25818 | 26502 | 10028.1
 | HIGH_C_BR27_03 |  |  |  |  |  | 8573.1 | 2124 | 118
 | HIGH_C_BR27_03 |  |  |  |  | 1298 | 6254 | 354 | 1062
 | LOW_C_JE25_02 | 7670 | 5310 | 4130 | 8372
 | LOW_C_JE25_02 | 7009 | 15576 | 5074 | 10729
 | LOW_C_MN25_18 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8956 | 14273 | 5784.8
 | LOW_C_MN25_18 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16862 | 8737 | 3417.3
 | HIGH_C_MN25_18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3492 | 826
 | EX129 | 15458 | 4832 | 1059 | 8673 |  | 1805 | 6328 | 13288 | 1573 | 14503.9 |  |  |  |  | 14263 | 3757 | 2124 | 8708 | 15930 | 12789 |  |  | 9225.4 | 24326.5 | 6745 | 8204
 | HIGH_E_BC21_08 | 15458 | 4832 | 1059 | 6322 |  | 1805 | 4718 | 5771 | 1573 | 14503.9 |  |  |  |  | 8962 | 3757
 | HIGH_E_BC21_08 |  |  |  | 2351 |  |  | 1610 | 7517 |  |  |  |  |  |  | 5301
 | LOW_E_JE17_05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 708 | 1298 | 8968 | 4484 |  |  | 1050 | 9304.9 | 2571 | 4811
 | LOW_E_JE17_05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1416 | 7410 | 2714 | 7479 |  |  | 6334.3 | 15021.6 | 4174 | 3393
 | HIGH_E_JE17_05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4248 | 826 |  |  | 1841.1
 | EX257 |  |  | 4276.5 | 463 |  |  |  |  |  |  |  | 1135 | 11568.1 |  |  | 3085 | 6040 |  |  |  | 354 | 8952 | 3149.3 | 1951.4 | 11623.4 | 11382
 | HIGH_C_TS31_33 |  |  | 4276.5 | 463 |  |  |  |  |  |  |  |  |  |  |  |  | 6040 |  |  |  | 354
 | HIGH_C_BRU30_27~ |  |  |  |  |  |  |  |  |  |  |  | 1135 | 11568.1 |  |  |  |  |  |  |  |  | 6623 | 3149.3 | 1951.4 | 6882 | 9082
 | HIGH_C_BRU30_27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970
 | HIGH_C_BRU30_27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2115 |  |  |  |  |  | 351
 | HIGH_C_BRU30_27~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1978 |  |  | 4741.4 | 2300
 | EX259 |  |  | 18075 | 9463.8 |  | 3981.1 | 17216.2 | 16492.1 | 15900 | 19047 | 17352 | 7753 |  |  |  |  |  |  | 15895 | 15438.9 | 17592.4 | 14872.3 | 21249.1 | 19798
 | HIGH_C_BR35_11~ |  |  | 12328 | 6396.7 |  | 3981.1 | 15232 | 11388.6 | 12901 | 9348 | 10997 | 5084 |  |  |  |  |  |  | 2015 | 2005
 | HIGH_C_BR35_11~ |  |  | 5747 | 3067.1 |  |  | 1984.2 | 5103.5 | 2999 | 9699 | 6355 | 2669 |  |  |  |  |  |  | 10080 | 785
 | LOW_C_JE28_10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2074.2 | 924 | 3073.1 | 3548.3 | 7262
 | LOW_C_BR35_11~ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3800
 | LOW_C_JE28_10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9429.7 | 12768.7 | 6377.2 | 13423.7 | 10427
 | HIGH_C_JE28_10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1145 | 3899.7 | 5422 | 4277.1 | 2109
 | EX262 |  |  |  |  |  |  |  |  |  | 9373.1 | 1873 |  |  | 1852 | 1038 | 4450 |  |  | 14307.6 | 3190.3
 | LOW_C_MN25_14 |  |  |  |  |  |  |  |  |  | 6048
 | LOW_C_MN25_14 |  |  |  |  |  |  |  |  |  | 3325.1
 | LOW_C_MN25_18 |  |  |  |  |  |  |  |  |  |  | 469
 | LOW_C_MN25_18 |  |  |  |  |  |  |  |  |  |  | 1404
 | HIGH_C_BC30_12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1852 | 1038 | 4120
 | LOW_C_JE28_10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 330 |  |  | 8019.5 | 576.3
 | LOW_C_JE28_10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6288.1 | 2114.8
 | HIGH_C_JE28_10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 499.2
 | Grand Total | 30137 | 25718 | 32614.5 | 37700.8 | 1298 | 20613.2 | 26022.2 | 30960.1 | 17473 | 42924 | 19225 | 8888 | 11568.1 | 27670 | 41803 | 21320.1 | 8164 | 8708 | 46132.6 | 31418.2 | 17946.4 | 23824.3 | 33623.8 | 46075.9 | 18368.4 | 19586