Spreadsheet: 84672d1284693703-combining-look-up-if-and-sumifs-sample-formula
Sheet: Data

CODE | QTY | DUE  DATE | TYPE | CLEARED (Y/N) | COMMITMENT | PLANNER
1000 | 1200 | 20100920 | ACI | Y |  | Gay
1000 | 2000 | 20101018 | ACI | N | C10919020- C10929020- C10931020- C10941023- I0043VMI I0092VMI I0238VMI I0367VMI I0454VMI I0487VMI I1037VMI I2061VMI I2375VMI I25849VMI I3527VMI I3805VMI | Gay
1000 | 2000 | 20101206 | ACI | N | C10919020- C10929020- C10931020- C10941023- I0043VMI I0087 I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2348VMI I2375VMI I23799 I25849VMI I3252VMI I3256VMI I3522 I3527VMI I3571VMI I3805VMI | Gay
1000 | 2000 | 20110124 | ACI | N |  | Gay
1000 | 2000 | 20110207 | ACI | N |  | Gay
1000 | 2000 | 20110314 | ACI | Y |  | Gay
1000 | 2000 | 20110502 | ACI | Y |  | Gay
1001 | 1200 | 20100915 | ACI | Y |  | Gay
1001 | 1200 | 20101011 | ACI | N | C10919020- C10929020- C10931020- I0092VMI I0367VMI I0820VMI I2061VMI I25849VMI I3527VMI | Gay
1001 | 2000 | 20101101 | ACI | N | C10919020- C10929020- C10931020- I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0454VMI I0487VMI I0505VMI I0820VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2375VMI I25849VMI I3252VMI I3527VMI I3805VMI | Gay
1001 | 1200 | 20101206 | ACI | N | C10919020- C10929020- C10931020- C10941024- I0043VMI I0087 I0092VMI I0209VMI I0238VMI I0367VMI I0454VMI I0487VMI I0505VMI I0820VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2375VMI I23799 I25849VMI I3252VMI I3256VMI I3522 I3527VMI I3571VMI I3805VMI | Gay
1004 | 1500 | 20101003 | ACI | N | a | Gay
1004 | 3000 | 20101024 | ACI | N | ab | Gay
1004 | 2500 | 20101030 | ACI | N | abc | Gay
1004 | 1200 | 20101107 | ACI | N | abcd | Gay
1004 | 1200 | 20101128 | ACI | N | abcde | Gay
1004 | 1200 | 20110114 | ACI | N | abcdef | Gay
1004 | 1200 | 20110128 | ACI | N | abcdefg | Gay
1004 | 1200 | 20110102 | ACI | N | abcdefgh | Gay
1005 | 1200 | 20100916 | ACI | Y |  | Gay
1016 | 2500 | 20101011 | ACI | N | C10780300- I0100VMI I0410VMI I1091VMI I2205VMI I3736VMI | [NAME]
1037 | 3000 | 20110110 | ACI | Y |  | [NAME]
1037 | 3000 | 20110328 | ACI | Y |  | [NAME]
1037 | 3000 | 20101003 | ACI | Y |  | [NAME]
1037 | 3000 | 20101004 | ACI | N | C10927080- C10950080- C10989080- C10993080- I0817VMI I1091VMI | [NAME]
1061 | 2000 | 20101025 | ACI | N | C10919020- C10929020- C10931020- C10941025- I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I1037VMI I1168VMI I2061VMI I25849VMI I3252VMI I3527VMI I3805VMI | Gay
1062 | 3000 | 20101115 | ACI | N | C10927080- C10941081- C10950080- C10989080- C10993080- I0100VMI I0142VMI I0410VMI I0565VMI I0817VMI I0885VMI I1-0743VMI I1091VMI I2279 I2288 I2427VMI I26429VMI I3022VMI I3940VMI | [NAME]
1089 | 2000 | 20101103 | ACI | Y |  | Gay
1089 | 2000 | 20101117 | ACI | Y |  | Gay
1089 | 10000 | 20101124 | ACI | Y |  | Gay
1089 | 2500 | 20101127 | ACI | Y |  | Gay
1089 | 1200 | 20101130 | ACI | Y |  | Gay
1089 | 1200 | 20101201 | ACI | Y |  | Gay
1089 | 1200 | 20101201 | ACI | Y |  | Gay
1089 | 1200 | 20101205 | ACI | Y |  | Gay
1089 | 1200 | 20101206 | ACI | Y |  | Gay
1089 | 1200 | 20101210 | ACI | Y |  | Gay
1089 | 1200 | 20101217 | ACI | Y |  | Gay
1089 | 1200 | 20101220 | ACI | Y |  | Gay
1089 | 1200 | 20101225 | ACI | Y |  | Gay
61024 | 2500 | 20101007 | ACI | Y |  | [NAME]
61024 | 2500 | 20101011 | ACI | N | C10780300- C10927090- I0297VMI I0410VMI I0611VMI I1091VMI I1-3661VMI I1-9601 | [NAME]
61024 | 2500 | 20101011 | ACI | N | C10780300- C10927090- [NAME] I0410VMI I0611VMI I1091VMI I1-3661VMI I1-9601 | [NAME]
61026 | 2000 | 20100927 | ACI | Y |  | Gay
61026 | 2000 | 20101027 | ACI | Y |  | Gay
61026 | 10000 | 20101117 | ACI | N | C10931020- | Gay
61026 | 5000 | 20101120 | ACI | N | C10919020- C10929020- C10931020- I0092VMI I0367VMI I2061VMI I25849VMI I3527VMI | Gay
61103 | 2000 | 20101125 | ACI | N | C10919020- C10929020- C10931020- C10941026- I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I1037VMI I1168VMI I2061VMI I2355VMI I2375VMI I25849VMI I3252VMI I3527VMI I3805VMI | Gay
61103 | 10000 | 20101115 | ACI | N | C10919020- C10929020- C10931020- C10941026- I0043VMI I0087 I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2355VMI I2375VMI I25849VMI I3252VMI I3527VMI I3571VMI I3805VMI | Gay
61103 | 3000 | 20101206 | ACI | N | C10919020- C10929020- C10931020- C10941026- I0043VMI I0087 I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2355VMI I2375VMI I23799 I25849VMI I3252VMI I3256VMI I3522 I3527VMI I3571VMI I3805VMI | Gay
71301 | 1200 | 20100914 | ACI | Y |  | Gay
71303 | 3000 | 20100927 | ACI | N | C10729300- C10731300- C10741301- | Gay
71304 | 1200 | 20101004 | ACI | N | C10729300- C10731300- C10741301- I0367VMI I0820VMI I2061VMI I3527VMI | Gay
71305 | 1200 | 20101108 | ACI | Y | C10729300- C10731300- C10741301- C10819090- I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0454VMI I0487VMI I0505VMI I0820VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2355VMI I2400VMI I2427VMI I25849VMI I2872VMI I3252VMI I3527VMI I3571VMI I3805VMI | Gay
71309 | 4000 | 20100914 | ACI | N | C10741303- | Gay
71311 | 3000 | 20101011 | ACI | N | C10729300- C10731300- C10741303- I0092VMI I0367VMI I0454VMI I0487VMI I0820VMI I1037VMI I2061VMI I2195VMI I2375VMI I2427VMI I25849VMI I3527VMI I3805VMI | Gay
71325 | 10000 | 20100913 | ACI | Y |  | Gay
71326 | 10000 | 20100914 | ACI | Y |  | Gay
71329 | 1500 | 20101011 | ACI | N | C10729300- C10731300- I0092VMI I0367VMI I0454VMI I0487VMI I0820VMI I1037VMI I2061VMI I25849VMI I3527VMI I3805VMI | Gay
71330 | 1200 | 20100920 | ACI | Y |  | Gay
71331 | 1200 | 20101011 | ACI | N | C10729300- C10731300- I0092VMI I0367VMI I0454VMI I0487VMI I0820VMI I1037VMI I2061VMI I25849VMI I2872VMI I3527VMI I3805VMI | Gay
71333 | 1500 | 20100914 | ACI | Y |  | Gay
71334 | 1500 | 20100914 | ACI | N | [NAME] | Gay
71339 | 3000 | 20100927 | ACI | N | I20939 | Rizza
71341 | 3000 | 20100927 | ACI | N | I20939 | Rizza
71344 | 3000 | 20100927 | ACI | N | I20939 | Rizza
71367 | 5800 | 20100915 | ACI | Y |  | Rizza
71374 | 2260 | 20100920 | ACI | Y |  | Rizza
71377 | 3000 | 20100916 | ACI | Y |  | Rizza
71381 | 3000 | 20100920 | ACI | Y |  | Rizza
71382 | 3000 | 20100927 | ACI | N | [NAME] | Rizza
71383 | 3000 | 20100916 | ACI | Y |  | Rizza
71384 | 1200 | 20101018 | ACI | N | C10729300- C10731300- I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I0820VMI I1037VMI I1168VMI I2061VMI I25849VMI I3252VMI I3527VMI I3805VMI | Gay
71385 | 1200 | 20100920 | ACI | Y |  | Gay
71402 | 1200 | 20101011 | ACI | N | C10729300- C10731300- I0092VMI I0367VMI I0454VMI I0487VMI I0820VMI I1037VMI I2061VMI I25849VMI I3527VMI I3805VMI | Gay
81059 | 1500 | 20100916 | ACI | Y |  | Gay
81059 | 2000 | 20101018 | ACI | N | C10919020- C10929020- C10931020- I0043VMI I0092VMI I0238VMI I0367VMI I0454VMI I0487VMI I0820VMI I1037VMI I2061VMI I2375VMI I2427VMI I25849VMI I3527VMI I3805VMI | Gay
81059 | 1500 | 20100927 | ACI | N | C10931020- | Gay
81100 | 1200 | 20101018 | ACI | N | C10729300 C10731300 I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I0820VMI I1037VMI I1168VMI I2061VMI I2375VMI I25849VMI I2872VMI I3252VMI I3527VMI I3805VMI | Gay
81102 | 5000 | 20100920 | ACI | Y |  | Rizza
81104 | 4300 | 20100927 | ACI | N | C10741374 | Rizza
81105 | 5000 | 20101115 | ACI | N | C10731303- C10741374- C10750313- I0087 I0209VMI I0238VMI I0460VMI I0487VMI I27539VMI I2864VMI I2872VMI I3252VMI I3527VMI I3571VMI I3805VMI | Rizza
81311 | 4000 | 20101220 | ACI | N | C10731303- C10741374- C10750313- I0087 I0209VMI I0238VMI I0460VMI I0487VMI I2224 I25859VMI I27539VMI I2864VMI I2872VMI I3252VMI I3329VMI I3527VMI I3571VMI I3805VMI | Rizza
81312 | 3000 | 20100920 | ACI | Y |  | Rizza
81390 | 3000 | 20101011 | ACI | N | I0487VMI I2872VMI I3527VMI I3805VMI | Rizza
81394 | 2000 | 20100913 | ACI | Y |  | Gay
81396 | 1500 | 20100920 | ACI | Y |  | Gay
81547 | 1200 | 20101011 | ACI | N | C10729300- C10731300- I0092VMI I0367VMI I0454VMI I0487VMI I0820VMI I1037VMI I2061VMI I25849VMI I3527VMI I3805VMI | Gay
91020 | 1200 | 20101108 | ACI | N | C10729300- C10731300- I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0454VMI I0487VMI I0505VMI I0820VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2355VMI I2403VMI I25849VMI I3252VMI I3527VMI I3571VMI I3805VMI | Gay
91021 | 1200 | 20101129 | ACI | N | C10729300- C10731300- I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0454VMI I0487VMI I0505VMI I0820VMI I1-0129VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2355VMI I23799 I2403VMI I25849VMI I3252VMI I3522 I3527VMI I3571VMI I3805VMI | Gay
91022 | 1500 | 20100913 | ACI | Y |  | Gay
91023 | 1500 | 20100914 | ACI | Y |  | Gay
91024 | 1200 | 20100920 | ACI | Y |  | Gay
91025 | 1200 | 20100920 | ACI | Y |  | Gay
91025 | 2500 | 20101101 | ACI | N | C10919020- C10929020- C10931020- I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I0820VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2353VMI I2375VMI I25849VMI I2784VMI I3252VMI I3527VMI I3805VMI | Gay
91025 | 1200 | 20101115 | ACI | N | C10919020- C10929020- C10931020- I0043VMI I0087 I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I0820VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2353VMI I2375VMI I25849VMI I2777VMI I2784VMI I3252VMI I3527VMI I3571VMI I3805VMI | Gay
91025 | 1500 | 20101206 | ACI | N | C10919020- C10929020- C10931020- I0043VMI I0087 I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I0811VMI I0820VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2353VMI I2375VMI I23799 I25849VMI I2777VMI I2784VMI I3252VMI I3256VMI I3522 I3527VMI I3571VMI I3805VMI | Gay
91026 | 3000 | 20100927 | ACI | N | I20939 | Rizza
91027 | 2000 | 20101004 | ACI | N | I0367VMI I0820VMI | Anna
91028 | 2000 | 20101115 | ACI | Y |  | Anna
91029 | 4500 | 20100927 | ACI | Y |  | [NAME]
91029 | 3000 | 20100920 | ACI | Y |  | [NAME]
91029 | 3000 | 20101025 | ACI | N | C10927080- C10950080- C10989080- C10993080- I0100VMI I0142VMI I0410VMI I0885VMI I1-0743VMI I1091VMI I2279 I2400VMI I26429VMI I3022VMI I3940VMI | [NAME]
91030 | 2000 | 20100917 | ACI | Y |  | Anna
91031 | 2000 | 20100917 | ACI | Y |  | Anna
91060 | 3000 | 20110103 | ACI | Y |  | [NAME]
91060 | 3000 | 20110214 | ACI | Y |  | [NAME]
91062 | 3000 | 20111003 | ACI | Y |  | Gay
91062 | 1200 | 20111024 | ACI | Y |  | Gay
91062 | 1200 | 20111115 | ACI | Y |  | Gay
91062 | 1200 | 20110114 | ACI | Y |  | Gay
91062 | 2500 | 20101018 | ACI | N | C10780300- C3051768- I0100VMI I0410VMI I0885VMI I1091VMI I2205VMI I3736VMI | [NAME]
91071 | 2000 | 20100917 | ACI | Y |  | Anna
91080 | 2000 | 20101206 | ACI | Y |  | Anna
91081 | 1200 | 20100920 | ACI | Y |  | Gay
91082 | 1500 | 20100915 | ACI | Y |  | Gay
91090 | 1200 | 20100920 | ACI | N | C10729300- C10731300- | Gay
91091 | 1200 | 20100927 | ACI | N | C10729300- C10731300- | Gay
91092 | 1200 | 20101018 | ACI | N | C10729300- C10731300- | Gay
91093 | 1200 | 20101101 | ACI | N | C10729300- C10731300- I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0454VMI I0487VMI I0505VMI I0820VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2375VMI I2427VMI I25849VMI I3252VMI I3527VMI I3805VMI | Gay
91100 | 5500 | 20100917 | ACI | Y |  | Rizza
91100 | 3000 | 20100913 | ACI | Y |  | [NAME]
91100 | 2500 | 20101004 | ACI | N | I1091VMI I1-3661VMI | [NAME]
91101 | 3500 | 20100917 | ACI | N | C10829390- | Rizza
91103 | 3000 | 20101101 | ACI | N | C10829390- I0209VMI I0238VMI I0487VMI I27539VMI I3252VMI I3527VMI I3805VMI | Rizza
91110 | 3000 | 20100920 | ACI | N | C10029037- | Rizza
91111 | 1500 | 20100915 | ACI | Y |  | Gay
91112 | 4000 | 20100920 | ACI | Y |  | Gay
91113 | 4000 | 20101011 | ACI | N | C10919020- C10929020- C10931020- C10941020- I0092VMI I0367VMI I0820VMI I2061VMI I25849VMI I3527VMI | Gay
91114 | 2000 | 20101213 | ACI | N | C10919020- C10929020- C10931020- C10941020- I0043VMI I0087 I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I0820VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2375VMI I23799 I25849VMI I2872VMI I3093VMI I3252VMI I3256VMI I3522 I3527VMI I3571VMI I3805VMI | Gay
91115 | 2000 | 20110117 | ACI | Y |  | Gay
91116 | 2000 | 20110307 | ACI | Y |  | Gay
91150 | 2000 | 20110425 | ACI | Y |  | Gay
91151 | 2000 | 20110613 | ACI | Y |  | Gay
91250 | 2000 | 20110627 | ACI | Y |  | Gay
91251 | 1200 | 20101018 | ACI | N | C10919020- C10929020- C10931020- C10941021- I0043VMI I0092VMI I0238VMI I0367VMI I0454VMI I0487VMI I1037VMI I2061VMI I2427VMI I25849VMI I3527VMI I3805VMI | Gay
91261 | 1200 | 20101101 | ACI | N | C10919020- C10929020- C10931020- C10941021- I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2427VMI I25849VMI I3252VMI I3527VMI I3805VMI | Gay
91262 | 1200 | 20101213 | ACI | N | C10919020- C10929020- C10931020- C10941021- I0043VMI I0087 I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I1037VMI I1150 I1168VMI I1-3409VMI I2061VMI I23799 I2427VMI I25849VMI I3252VMI I3256VMI I3522 I3527VMI I3571VMI I3805VMI | Gay
91263 | 2500 | 20110103 | ACI | Y |  | Gay
91264 | 1200 | 20110124 | ACI | Y |  | Gay
91330 | 1200 | 20100915 | ACI | Y |  | Gay
91331 | 1200 | 20100920 | ACI | Y |  | Gay
91332 | 2000 | 20101018 | ACI | N | C10919020- C10929020- C10931020- C10941022- I0043VMI I0092VMI I0238VMI I0367VMI I0454VMI I0487VMI I0820VMI I1037VMI I2061VMI I25849VMI I2872VMI I3527VMI I3805VMI | Gay
91380 | 1200 | 20101206 | ACI | N | C10919020- C10929020- C10931020- C10941022- I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0454VMI I0487VMI I0505VMI I0820VMI I1037VMI I1168VMI I1-3409VMI I2061VMI I2355VMI I23799 I25849VMI I2777VMI I2784VMI I2872VMI I3093VMI I3252VMI I3256VMI I3522 I3527VMI I3571VMI I3805VMI | Gay
91381 | 1500 | 20101220 | ACI | N | C10919020- C10929020- C10931020- C10941022- I0043VMI I0092VMI I0209VMI I0238VMI I0367VMI I0454VMI I0487VMI I0505VMI I0820VMI I1037VMI I1168VMI I1-3409VMI I2031VMI I2061VMI I2224 I2355VMI I23799 I25849VMI I2777VMI I2784VMI I2872VMI I3093VMI I3252VMI I3256VMI I3522 I3527VMI I3571VMI I3805VMI | Gay
91382 | 2500 | 20110117 | ACI | Y |  | Gay
91440 | 1200 | 20110307 | ACI | Y |  | Gay
 | 1200 | 20101213 | ACI | N | C10919020- C10929020- C10931020- C10941026- I0043VMI I0087 I0092VMI I0209VMI I0238VMI I0367VMI I0449VMI I0454VMI I0487VMI I0505VMI I1037VMI I1168VMI I1-3409VMI I2031VMI I2061VMI I2355VMI I2375VMI I23799 I25849VMI I3252VMI I3256VMI I3522 I3527VMI I3571VMI I3805VMI | Gay
 | 2000 | 20101227 | ACI | Y |  | Gay