Spreadsheet: 71725d1272465812-how-to-use-sumproduct-and-ignore-formulas-test
Sheet: Data

Order Raised Date | Despatch Date | Days to Despatch
2009-12-22 00:00:00 | 2010-01-21 00:00:00 | 30 |  |  |  | 87
2009-12-01 00:00:00 | 2009-12-30 00:00:00 | 29
2009-12-01 00:00:00 | 2010-01-07 00:00:00 | 37
2009-12-01 00:00:00 | 2010-01-07 00:00:00 | 37
2009-12-01 00:00:00 | 2009-12-23 00:00:00 | 22
2009-12-01 00:00:00 | 2009-12-18 00:00:00 | 17
2009-12-02 00:00:00 | 2010-01-23 00:00:00 | 52
2009-12-02 00:00:00
2009-12-02 00:00:00 | 2010-01-20 00:00:00 | 49
2009-12-02 00:00:00 | 2009-12-23 00:00:00 | 21
2009-12-03 00:00:00
2009-12-03 00:00:00
2009-12-03 00:00:00
2009-12-03 00:00:00 | 2009-12-31 00:00:00 | 28
2009-12-03 00:00:00 | 2010-03-26 00:00:00 | 113
2009-12-04 00:00:00 | 2010-02-02 00:00:00 | 60
2009-12-04 00:00:00 | 2009-12-30 00:00:00 | 26
2009-12-04 00:00:00
2009-12-04 00:00:00 | 2010-01-11 00:00:00 | 38
2009-12-06 00:00:00 | 2010-01-05 00:00:00 | 30
2009-12-06 00:00:00
2009-12-07 00:00:00 | 2010-03-09 00:00:00 | 92
2009-12-07 00:00:00
2009-12-07 00:00:00 | 2010-01-06 00:00:00 | 30
2009-12-07 00:00:00
2009-12-08 00:00:00
2009-12-08 00:00:00 | 2010-02-05 00:00:00 | 59
2009-12-08 00:00:00 | 2010-03-26 00:00:00 | 108
2009-12-08 00:00:00
2009-12-09 00:00:00 | 2010-01-18 00:00:00 | 40
2009-12-09 00:00:00
2009-12-09 00:00:00 | 2010-04-10 00:00:00 | 122
2009-12-09 00:00:00 | 2010-02-15 00:00:00 | 68
2009-12-10 00:00:00 | 2010-01-06 00:00:00 | 27
2009-12-12 00:00:00 | 2010-01-08 00:00:00 | 27
2009-12-13 00:00:00
2009-12-13 00:00:00
2009-12-14 00:00:00 | 2010-02-19 00:00:00 | 67
2009-12-14 00:00:00
2009-12-14 00:00:00 | 2010-01-28 00:00:00 | 45
2009-12-14 00:00:00
2009-12-14 00:00:00 | 2010-04-19 00:00:00 | 126
2009-12-14 00:00:00 | 2010-01-12 00:00:00 | 29
2009-12-15 00:00:00 | 2010-01-20 00:00:00 | 36
2009-12-15 00:00:00
2009-12-15 00:00:00 | 2010-02-09 00:00:00 | 56
2009-12-17 00:00:00 | 2010-01-15 00:00:00 | 29
2009-12-17 00:00:00 | 2010-01-13 00:00:00 | 27
2009-12-17 00:00:00
2009-12-18 00:00:00 | 2010-01-13 00:00:00 | 26
2009-12-18 00:00:00 | 2010-03-01 00:00:00 | 73
2009-12-19 00:00:00 | 2010-01-21 00:00:00 | 33
2009-12-20 00:00:00 | 2010-01-18 00:00:00 | 29
2009-12-20 00:00:00 | 2010-03-17 00:00:00 | 87
2009-12-21 00:00:00 | 2010-02-02 00:00:00 | 43
2009-12-21 00:00:00 | 2010-03-17 00:00:00 | 86
2009-12-21 00:00:00 | 2010-01-19 00:00:00 | 29
2009-12-21 00:00:00 | 2010-03-31 00:00:00 | 100
2009-12-21 00:00:00
2009-12-21 00:00:00 | 2010-02-01 00:00:00 | 42
2009-12-22 00:00:00 | 2010-02-08 00:00:00 | 48
2009-12-22 00:00:00 | 2010-01-22 00:00:00 | 31
2009-12-22 00:00:00 | 2010-01-18 00:00:00 | 27
2009-12-23 00:00:00 | 2010-03-30 00:00:00 | 97
2009-12-23 00:00:00 | 2010-01-19 00:00:00 | 27
2009-12-23 00:00:00 | 2010-02-13 00:00:00 | 52
2009-12-23 00:00:00 | 2010-01-20 00:00:00 | 28
2009-12-23 00:00:00 | 2010-01-21 00:00:00 | 29
2009-12-24 00:00:00 | 2010-01-15 00:00:00 | 22
2009-12-24 00:00:00 | 2010-01-21 00:00:00 | 28
2009-12-24 00:00:00 | 2010-01-22 00:00:00 | 29
2009-12-27 00:00:00 | 2010-02-01 00:00:00 | 36
2009-12-31 00:00:00 | 2010-02-09 00:00:00 | 40
2009-12-31 00:00:00 | 2010-02-10 00:00:00 | 41
2009-12-01 00:00:00 | 2010-02-08 00:00:00 | 69
2009-12-02 00:00:00 | 2009-12-23 00:00:00 | 21
2009-12-03 00:00:00
2009-12-03 00:00:00 | 2009-12-23 00:00:00 | 20
2009-12-03 00:00:00
2009-12-03 00:00:00 | 2010-01-26 00:00:00 | 54
2009-12-05 00:00:00 | 2010-01-08 00:00:00 | 34
2009-12-06 00:00:00 | 2009-12-31 00:00:00 | 25
2009-12-06 00:00:00 | 2010-02-06 00:00:00 | 62
2009-12-07 00:00:00 | 2010-02-19 00:00:00 | 74
2009-12-07 00:00:00 | 2010-01-04 00:00:00 | 28
2009-12-07 00:00:00 | 2010-04-16 00:00:00 | 130
2009-12-07 00:00:00 | 2009-12-22 00:00:00 | 15
2009-12-08 00:00:00 | 2010-02-11 00:00:00 | 65
2009-12-08 00:00:00
2009-12-11 00:00:00 | 2010-01-11 00:00:00 | 31
2009-12-11 00:00:00
2009-12-11 00:00:00
2009-12-11 00:00:00
2009-12-12 00:00:00 | 2010-01-08 00:00:00 | 27
2009-12-14 00:00:00
2009-12-14 00:00:00 | 2010-01-11 00:00:00 | 28
2009-12-15 00:00:00 | 2010-01-13 00:00:00 | 29
2009-12-15 00:00:00 | 2010-04-08 00:00:00 | 114
2009-12-15 00:00:00 | 2010-01-11 00:00:00 | 27
2009-12-15 00:00:00 | 2010-01-11 00:00:00 | 27
2009-12-16 00:00:00 | 2010-01-12 00:00:00 | 27
2009-12-17 00:00:00
2009-12-17 00:00:00 | 2010-01-15 00:00:00 | 29
2009-12-18 00:00:00 | 2010-01-15 00:00:00 | 28
2009-12-18 00:00:00 | 2010-02-03 00:00:00 | 47
2009-12-19 00:00:00 | 2010-01-18 00:00:00 | 30
2009-12-21 00:00:00 | 2010-01-28 00:00:00 | 38
2009-12-21 00:00:00 | 2010-04-07 00:00:00 | 107
2009-12-21 00:00:00
2009-12-21 00:00:00 | 2010-03-19 00:00:00 | 88
2009-12-22 00:00:00 | 2010-02-10 00:00:00 | 50
2009-12-22 00:00:00 | 2010-01-30 00:00:00 | 39
2009-12-22 00:00:00 | 2010-01-23 00:00:00 | 32
2009-12-22 00:00:00 | 2010-01-20 00:00:00 | 29
2009-12-22 00:00:00
2009-12-22 00:00:00 | 2010-04-14 00:00:00 | 113
2009-12-23 00:00:00 | 2010-01-18 00:00:00 | 26
2009-12-24 00:00:00
2009-12-27 00:00:00 | 2010-01-25 00:00:00 | 29
2009-12-29 00:00:00 | 2010-03-22 00:00:00 | 83
2009-12-01 00:00:00 | 2009-12-31 00:00:00 | 30
2009-12-01 00:00:00 | 2009-12-29 00:00:00 | 28
2009-12-02 00:00:00 | 2010-03-22 00:00:00 | 110
2009-12-03 00:00:00 | 2010-01-08 00:00:00 | 36
2009-12-03 00:00:00 | 2010-03-12 00:00:00 | 99
2009-12-03 00:00:00 | 2010-03-10 00:00:00 | 97
2009-12-03 00:00:00
2009-12-03 00:00:00 | 2010-01-06 00:00:00 | 34
2009-12-04 00:00:00
2009-12-05 00:00:00 | 2010-01-25 00:00:00 | 51
2009-12-07 00:00:00 | 2010-01-14 00:00:00 | 38
2009-12-07 00:00:00 | 2010-01-04 00:00:00 | 28
2009-12-07 00:00:00 | 2010-02-03 00:00:00 | 58
2009-12-08 00:00:00 | 2010-01-07 00:00:00 | 30
2009-12-08 00:00:00
2009-12-08 00:00:00 | 2010-01-07 00:00:00 | 30
2009-12-08 00:00:00 | 2010-01-07 00:00:00 | 30
2009-12-09 00:00:00 | 40231 | 75
2009-12-09 00:00:00
2009-12-10 00:00:00 | 2010-03-15 00:00:00 | 95
2009-12-12 00:00:00
2009-12-14 00:00:00 | 2010-01-19 00:00:00 | 36
2009-12-14 00:00:00 | 2010-03-18 00:00:00 | 94
2009-12-14 00:00:00 | 2010-01-12 00:00:00 | 29
2009-12-14 00:00:00
2009-12-14 00:00:00 | 2010-01-06 00:00:00 | 23
2009-12-15 00:00:00 | 2010-01-28 00:00:00 | 44
2009-12-15 00:00:00 | 2010-01-14 00:00:00 | 30
2009-12-15 00:00:00 | 2010-02-06 00:00:00 | 53
2009-12-16 00:00:00 | 2010-01-15 00:00:00 | 30
2009-12-16 00:00:00 | 2010-03-15 00:00:00 | 89
2009-12-16 00:00:00 | 2010-01-15 00:00:00 | 30
2009-12-17 00:00:00
2009-12-17 00:00:00 | 2010-03-31 00:00:00 | 104
2009-12-17 00:00:00 | 2010-01-23 00:00:00 | 37
2009-12-17 00:00:00 | 2010-02-25 00:00:00 | 70
2009-12-18 00:00:00 | 2010-01-28 00:00:00 | 41
2009-12-21 00:00:00 | 2010-01-29 00:00:00 | 39
2009-12-21 00:00:00 | 2010-01-29 00:00:00 | 39
2009-12-21 00:00:00 | 2010-01-27 00:00:00 | 37
2009-12-21 00:00:00
2009-12-21 00:00:00 | 2010-01-15 00:00:00 | 25
2009-12-22 00:00:00 | 2010-01-21 00:00:00 | 30
2009-12-22 00:00:00 | 2010-01-16 00:00:00 | 25
2009-12-23 00:00:00 | 2010-01-19 00:00:00 | 27
2009-12-23 00:00:00
2009-12-23 00:00:00 | 2010-01-22 00:00:00 | 30
2009-12-23 00:00:00 | 2010-02-18 00:00:00 | 57
2009-12-23 00:00:00 | 2010-01-20 00:00:00 | 28
2009-12-27 00:00:00 | 2010-01-28 00:00:00 | 32
2009-12-28 00:00:00 | 2010-01-28 00:00:00 | 31
2009-12-31 00:00:00 | 2010-02-10 00:00:00 | 41
2009-12-31 00:00:00 | 2010-01-21 00:00:00 | 21
2009-12-01 00:00:00 | 2010-02-05 00:00:00 | 66
2009-12-01 00:00:00 | 2009-12-24 00:00:00 | 23
2009-12-02 00:00:00
2009-12-02 00:00:00
2009-12-03 00:00:00 | 2010-02-11 00:00:00 | 70
2009-12-03 00:00:00 | 2010-01-27 00:00:00 | 55
2009-12-03 00:00:00 | 2009-12-22 00:00:00 | 19
2009-12-04 00:00:00 | 2010-01-26 00:00:00 | 53
2009-12-05 00:00:00
2009-12-05 00:00:00 | 2009-12-31 00:00:00 | 26
2009-12-06 00:00:00 | 2010-04-09 00:00:00 | 124
2009-12-07 00:00:00 | 2010-01-07 00:00:00 | 31
2009-12-07 00:00:00 | 2010-01-06 00:00:00 | 30
2009-12-08 00:00:00
2009-12-08 00:00:00 | 2010-01-08 00:00:00 | 31
2009-12-08 00:00:00 | 2010-01-22 00:00:00 | 45
2009-12-08 00:00:00
2009-12-08 00:00:00 | 2010-01-07 00:00:00 | 30
2009-12-09 00:00:00 | 2010-01-08 00:00:00 | 30
2009-12-09 00:00:00 | 2010-02-11 00:00:00 | 64
2009-12-14 00:00:00 | 40204 | 43
2009-12-14 00:00:00 | 2010-01-13 00:00:00 | 30
2009-12-14 00:00:00 | 2010-01-08 00:00:00 | 25
2009-12-14 00:00:00 | 2010-01-12 00:00:00 | 29
2009-12-15 00:00:00 | 2010-01-14 00:00:00 | 30
2009-12-15 00:00:00 | 2010-02-08 00:00:00 | 55
2009-12-16 00:00:00 | 2010-01-14 00:00:00 | 29
2009-12-16 00:00:00 | 2010-01-22 00:00:00 | 37
2009-12-16 00:00:00 | 2010-02-20 00:00:00 | 66
2009-12-16 00:00:00 | 2010-01-26 00:00:00 | 41
2009-12-16 00:00:00 | 2010-01-12 00:00:00 | 27
2009-12-17 00:00:00 | 2010-01-15 00:00:00 | 29
2009-12-17 00:00:00 | 2010-04-26 00:00:00 | 130
2009-12-17 00:00:00 | 2010-01-13 00:00:00 | 27
2009-12-18 00:00:00 | 2010-02-13 00:00:00 | 57
2009-12-18 00:00:00
2009-12-19 00:00:00 | 2010-04-01 00:00:00 | 103
2009-12-22 00:00:00 | 2010-04-16 00:00:00 | 115
2009-12-22 00:00:00 | 2010-01-21 00:00:00 | 30
2009-12-22 00:00:00
2009-12-23 00:00:00 | 2010-03-15 00:00:00 | 82
2009-12-24 00:00:00 | 40248 | 77
2009-12-24 00:00:00 | 2010-02-03 00:00:00 | 41
2009-12-26 00:00:00 | 2010-01-20 00:00:00 | 25
2009-12-29 00:00:00 | 2010-01-29 00:00:00 | 31
2009-12-29 00:00:00 | 2010-02-13 00:00:00 | 46
2009-12-29 00:00:00 | 2010-01-27 00:00:00 | 29
2009-12-30 00:00:00 | 40277 | 100