Spreadsheet: 122473d1316831225-sumifs-returns-0-when-i-dont-want-it-to-sumifs_example
Sheet: Sheet3

LotID | LOTID |  |  |  |  | LotID |  |  | LOTID
20050104 | 20050104 |  | A1 |  |  | 20101236 |  |  | 20101236
20050182 | 20050182 |  | A2 |  |  | 20070360 |  |  | 20070360
20050182 |  |  | A3 |  |  | 20060289 |  |  | 20060289
20050182 |  |  | A4 |  |  | 20050182 |  |  | 20050182
20050182 |  |  | A5 |  |  | 20050182 |  |  | 20050222
20050182 |  |  | A6 |  |  | 20060289 |  |  | 20050104
20050222 | 20050222 |  | A7 |  |  | 20050182 |  |  | 20101236
20050222 |  |  | A8 |  |  | 20050222 |  |  | 20090403
20050222 |  |  | A9 |  |  | 20060289 |  |  | 20090203
20050222 |  |  | A10 |  |  | 20050104 |  |  | 20101218
20050222 |  |  | A11 |  |  | 20060289 |  |  | 20050233
20050222 |  |  | A12 |  |  | 20050222 |  |  | 20090511
20050222 |  |  | A13 |  |  | 20050222 |  |  | 20090670
20050222 |  |  | A14 |  |  | 20050222 |  |  | 20070208
20050233 | 20050233 |  | A15 |  |  | 20050182 |  |  | 20080394
20050233 |  |  | A16 |  |  | 20050182 |  |  | 20080099
20050233 |  |  | A17 |  |  | 20050222 |  |  | 20080234
20050256 | 20050256 |  | A18 |  |  | 20050222 |  |  | 20062007
20060163 | 20060163 |  | A19 |  |  | 20060289 |  |  | 20070277
20060289 | 20060289 |  | A20 |  |  | 20050222 |  |  | 20080093
20060289 |  |  | A21 |  |  | 20070360 |  |  | 20070363
20060289 |  |  | A22 |  |  | 20101236 |  |  | 20100754
20060289 |  |  | A23 |  |  | 20090403 |  |  | 20100761
20060289 |  |  | A24 |  |  | 20090203 |  |  | 20090686
20062007 | 20062007 |  | A25 |  |  | 20101218 |  |  | 20070211
20062007 |  |  | A26 |  |  | 20050233 |  |  | 20090168
20070208 | 20070208 |  | A27 |  |  | 20090511 |  |  | 20070782
20070208 |  |  | A28 |  |  | 20090670 |  |  | 20101352
20070208 |  |  | A29 |  |  | 20070208 |  |  | 20101227
20070208 |  |  | A30 |  |  | 20080394 |  |  | 20090167
20070211 | 20070211 |  | A31 |  |  | 20080099 |  |  | 20090402
20070277 | 20070277 |  | A32 |  |  | 20050233 |  |  | 20101155
20070277 |  |  | A33 |  |  | 20080234 |  |  | 20050256
20070277 |  |  | A34 |  |  | 20101218 |  |  | 20101154
20070360 | 20070360 |  | [NAME] |  |  | 20080099 |  |  | 20060163
20070360 |  |  | A36 |  |  | 20062007
20070360 |  |  | A37 |  |  | 20070277
20070363 | 20070363 |  | A38 |  |  | 20080093
20070363 |  |  | A39 |  |  | 20070363
20070782 | 20070782 |  | A40 |  |  | 20080394
20080093 | 20080093 |  | A41 |  |  | 20070208
20080093 |  |  | A42 |  |  | 20090670
20080093 |  |  | A43 |  |  | 20080234
20080099 | 20080099 |  | [NAME] |  |  | 20080093
20080099 |  |  | A45 |  |  | 20070277
20080234 | 20080234 |  | A46 |  |  | 20070363
20080234 |  |  | A47 |  |  | 20062007
20080234 |  |  | A48 |  |  | 20090203
20080394 | 20080394 |  | A49 |  |  | 20090403
20080394 |  |  | [NAME] |  |  | 20100754
20080394 |  |  | A51 |  |  | 20101236
20090167 | 20090167 |  | A52 |  |  | 20080234
20090168 | 20090168 |  | A53 |  |  | 20070360
20090203 | 20090203 |  | [NAME] |  |  | 20090403
20090203 |  |  | A55 |  |  | 20090203
20090203 |  |  | [NAME] |  |  | 20090670
20090203 |  |  | A57 |  |  | 20070208
20090402 | 20090402 |  | A58 |  |  | 20100761
20090403 | 20090403 |  | A59 |  |  | 20090686
20090403 |  |  | A60 |  |  | 20070211
20090403 |  |  | A61 |  |  | 20050233
20090403 |  |  | A62 |  |  | 20090168
20090511 | 20090511 |  | A63 |  |  | 20070208
20090670 | 20090670 |  | A64 |  |  | 20070277
20090670 |  |  | A65 |  |  | 20070782
20090670 |  |  | A66 |  |  | 20101352
20090686 | 20090686 |  | A67 |  |  | 20101227
20090686 |  |  | A68 |  |  | 20090203
20100754 | 20100754 |  | A69 |  |  | 20080394
20100761 | 20100761 |  | A70 |  |  | 20101218
20101154 | 20101154 |  | [NAME] |  |  | 20090167
20101155 | 20101155 |  | A72 |  |  | 20090402
20101218 | 20101218 |  | A73 |  |  | 20090403
20101218 |  |  | A74 |  |  | 20080093
20101218 |  |  | A75 |  |  | 20101155
20101227 | 20101227 |  | A76 |  |  | 20050256
20101236 | 20101236 |  | A77 |  |  | 20101154
20101236 | 20101236 |  | A78 |  |  | 20060163
20101236 |  |  | A79 |  |  | 20090686
20101352 | 20101352 |  | A80 |  |  | 20050222