Spreadsheet: 714826d1611393931-return-sums-from-multiple-columns-with-criteria-oct-nov-dec-2020
Sheet: NOV-2020

 |  | NOVEMBER-2020
INVOICE | AMOUNT | PAYMENT TYPE | INVOICE | AMOUNT | PAYMENT TYPE | INVOICE | AMOUNT | PAYMENT TYPE
130101 | 489.9 | Span | 130299 | 57.5 | Span | 130506 | 100.05 |  |  | Span
130102 | 217.93 | Span | 130300 | 304.99 |  | 130507 | 27.77 |  |  | Bank Trns
130103 | 55.2 | Span | 130301 | 500.25 |  | 130508 | 414 |  |  | Cheque [NAME]
130104 | 178.25 |  | 130302 | 969.45 |  | 130509 | 1380 | Span |  | Cash
130105 | 514.34 | Span | 130303 | 23.57 |  | 130510 | 163.88
130106 | 23 | Span | 130304 | 112.7 | Span | 130511 | 9.2
130107 | 92 |  | 130305 | 994.75 |  | 130512 | 280.6
130108 | 10.35 |  | 130306 | 832.6 |  | 130513 | 89.13
130109 | 11.5 |  | 130307 | 359.37 | Span | 130514 | 17.25
130110 | 900 | Span | 130308 | 227.7 | Span | 130516 | 25.3
130111 | 44.27 |  | 130309 | 5.75 |  | 130517 | 17.25
130112 | 127.65 |  | 130310 | 11.5 |  | 130518 | 17.25
130113 | 15602.94 | Bank Trns | 130311 | 69 |  | 130519 | 44.85
130114 | 5.75 |  | 130312 | 1564 |  | 130520 | 20.7
130115 | 59.8 | Span | 130313 | 14.95 |  | 130521 | 200.68 | Span
130116 | 11.5 |  | 130314 | 89.7 | Span | 130522 | 18.4
130117 | 9838.25 | Bank Trns | 130315 | 258.75 | Span | 130523 | 19.55
130118 | 32996.95 | Bank Trns | 130316 | 995.9 | Span | 130525 | 2070
130119 | 97.75 |  | 130317 | 33.35 |  | 130526 | 457.7
130120 | 210.45 | Span | 130319 | 92 |  | 130527 | 9.2
130121 | 120.75 |  | 130320 | 175.95 |  | 130528 | 16.1
130122 | 1242 | Span | 130321 | 94.88 | Span | 130529 | 103.5
130124 | 33.93 | Span | 130322 | 7.47 |  | 130530 | 201.25
130125 | 184.57 |  | 130323 | 1978.86 |  | 130531 | 150.65
130126 | 80.21 | Span | 130324 | 43.7 |  | 130532 | 400.2
130127 | 310.5 |  | 130325 | 11.5 |  | 130533 | 2760
130128 | 142.6 | Span | 130326 | 39.96 |  | 130534 | 8.05 | Span
130129 | 87.4 |  | 130327 | 339.82 |  | 130535 | 18.97 | Span
130130 | 9.2 |  | 130328 | 76.47 | Span | 130536 | 50.03
130131 | 276 |  | 130329 | 870.55 |  | 130537 | 75.32 | Span
130132 | 630.2 |  | 130330 | 240.12 | Span | 130538 | 138
130133 | 89.7 |  | 130331 | 40.25 |  | 130539 | 501.4
130134 | 51.75 |  | 130332 | 90.85 | Span | 130540 | 389.85 | Span
130135 | 10.35 |  | 130334 | 46 |  | 130542 | 414
130136 | 177.1 | Span | 130335 | 110.4 | Span | 130543 | 230
130137 | 112.7 | Span | 130336 | 40.25 |  | 130544 | 18.4
130138 | 186.3 | Span | 130338 | 1060.3 | Span | 130545 | 133.98
130139 | 50.6 |  | 130339 | 11.5 |  | 130546 | 207
130140 | 16.1 |  | 130340 | 34.5 |  | 130547 | 11.79
130141 | 330.05 | Span | 130341 | 42.55 |  | 130548 | 92
130142 | 12.65 |  | 130342 | 851 |  | 130549 | 23
130143 | 57.5 | Span 900sr | 130343 | 44.85 | Span | 130550 | 200.1 | Span
130145 | 166.75 | Span | 130344 | 209.3 |  | 130551 | 210.45 | Span
130146 | 18.4 |  | 130345 | 92 | Span | 130552 | 242.65
130147 | 11.5 | Span | 130346 | 55.2 |  | 130553 | 86.25
130148 | 48.3 |  | 130347 | 400.2 | Span | 130554 | 196.36
130149 | 3.45 |  | 130349 | 85.1 | Span | 130555 | 805
130150 | 133.4 |  | 130350 | 10.35 |  | 130556 | 10.35 | Span
130151 | 171.35 |  | 130351 | 820.01 |  | 130557 | 14.95
130152 | 60.66 | Span | 130352 | 378.92 |  | 130558 | 140.3 | Span
130153 | 25.07 |  | 130354 | 15.52 |  | 130559 | 129.95
130154 | 730.25 |  | 130355 | 17.25 |  | 130560 | 910.8 | Span
130155 | 274.85 |  | 130356 | 136.85 |  | 130561 | 14.95 | Span
130156 | 126.5 |  | 130358 | 207 |  | 130562 | 112.12 | Span 127sr
130157 | 32.2 |  | 130359 | 178.25 |  | 130563 | 2.88
130158 | 900.45 |  | 130360 | 249.43 |  | 130564 | 1750.3 | Span
130160 | 40.25 |  | 130361 | 201.25 |  | 130565 | 4.6
130161 | 250.01 |  | 130362 | 17.83 |  | 130566 | 25.3 | Span
130162 | 529 | Span | 130363 | 23 |  | 130567 | 67.85 | Span
130163 | 52.9 | Span | 130364 | 75.32 |  | 130568 | 16.1
130164 | 28.75 |  | 130365 | 51.75 |  | 130569 | 289.8 | Span
130165 | 175.95 |  | 130366 | 439.3 | Span | 130570 | 112.7 | Span
130167 | 20.13 | Span | 130367 | 384.1 |  | 130571 | 55.2
130168 | 80.01 |  | 130368 | 216.11 | Span | 130572 | 40.25
130169 | 10.35 |  | 130369 | 184 | Span | 130573 | 120.75
130170 | 109.25 | Span | 130370 | 55.2 |  | 130574 | 80.5 | Span
130171 | 23 | Span | 130371 | 103.5 |  | 130576 | 293.25
130172 | 563.16 | Span | 130372 | 169.05 | Span | 130577 | 662.4
130173 | 64.69 |  | 130373 | 300.15 |  | 130578 | 36.22
130174 | 269.1 | Span | 130374 | 280.6 |  | 130579 | 11.5
130175 | 55.2 |  | 130375 | 186.88 |  | 130580 | 14.95
130176 | 147.2 |  | 130376 | 2070 | Bank Trnf | 130581 | 149.5
130177 | 5.75 |  | 130377 | 125.35 | Span | 130582 | 285.78 | Span
130179 | 33.06 |  | 130378 | 327.75 | Span | 130583 | 18.4
130181 | 124.2 |  | 130379 | 89.7 | Span | 130584 | 69
130182 | 97.75 |  | 130381 | 55.2 |  | 130585 | 212.75
130183 | 182.85 | Span | 130382 | 18.97 | Span | 130586 | 274.27
130184 | 16.1 |  | 130383 | 37.95 |  | 130587 | 100.05 | Span
130185 | 97.75 |  | 130384 | 51.75 | Span | 130588 | 190.32 | Span
130186 | 41.4 | Span | 130385 | 50.6 |  | 130589 | 52.9 | Span
130187 | 1109.75 | Span | 130386 | 977.5 |  | 130590 | 25.3 | Span
130188 | 983.82 |  | 130387 | 40.25 | Span | 130591 | 41.4 | Span
130189 | 297.56 |  | 130390 | 26.45 |  | 130592 | 80.5
130190 | 25.3 |  | 130391 | 276 |  | 130593 | 35.65
130191 | 37.95 |  | 130392 | 52.9 | Span | 130594 | 153.52 | Span
130192 | 92 |  | 130393 | 719.9 |  | 130595 | 75.32
130193 | 40.25 |  | 130394 | 46 |  | 130596 | 150.07 | Span
130194 | 74.75 |  | 130395 | 18.4 |  | 130599 | 77.05
130195 | 570.4 | Span | 130396 | 172.5 |  | 130600 | 87.4
130196 | 471.5 |  | 130397 | 1700.85 | Span 200 | 130601 | 240.93
130197 | 23 |  | 130398 | 42.55 |  | 130602 | 699.2
130198 | 110.4 |  | 130399 | 140.3 |  | 130603 | 36.8 | Span
130199 | 85.1 | Span | 130400 | 29.9 | Span | 130604 | 32.2
130200 | 800.4 | Span | 130401 | 97.75 |  | 130605 | 124.2
130201 | 25.88 |  | 130402 | 10.35 |  | 130606 | 86.25 | Span
130202 | 500.25 | Span | 130403 | 980.95 | Span | 130607 | 17.25
130204 | 32.2 | Span | 130404 | 253 |  | 130608 | 108.1
130205 | 267.37 |  | 130405 | 8.05 |  | 130609 | 25.88
130208 | 65.55 | Span | 130406 | 790.04 | Span | 130610 | 379.5 | Span
130209 | 132.25 |  | 130407 | 79.35 |  | 130611 | 1247.75
130210 | 3415.5 | Span | 130409 | 17.25 |  | 130612 | 506
130211 | 737.63 | Span 37.63 sr | 130410 | 925.75 | Span | 130613 | 23
130213 | 86.25 | Span | 130411 | 96.6 | Span | 130614 | 138
130214 | 25.3 |  | 130412 | 40.25 |  | 130615 | 181.7
130215 | 31.05 |  | 130413 | 385.25 | Span | 130616 | 17.25
130216 | 327.75 | Span | 130414 | 450.8 | Span | 130617 | 58.65 | Span
130217 | 100.05 |  | 130415 | 10.92 |  | 130618 | 510.6
130218 | 1279.95 | Span | 130416 | 27.6 |  | 130619 | 86.25
130219 | 95.45 |  | 130417 | 44.85 |  | 130620 | 934.5 | Span
130222 | 124.2 | Span | 130418 | 69 |  | 130621 | 231.15
130224 | 69 | Span | 130419 | 23 |  | 130622 | 900 | Span
130226 | 5.17 |  | 130421 | 59.8 |  | 130623 | 243.8 | Span
130227 | 42.55 |  | 130422 | 71.88 |  | 130624 | 239.2
130228 | 23 |  | 130423 | 57.5 | Span | 130625 | 10.35
130229 | 13.8 | Span | 130424 | 229.77 |  | 130626 | 264.5 | Span
130230 | 24.15 |  | 130425 | 18.4 | Span | 130627 | 592.25
130231 | 201.25 |  | 130426 | 27.6 | Span | 130629 | 104.65
130232 | 610.42 | Span | 130427 | 38.64 |  | 130630 | 399.05 | Span
130233 | 92.58 |  | 130428 | 287.5 | Span | 130631 | 118.45
130234 | 97.75 |  | 130430 | 132.25 |  | 130632 | 8.63
130235 | 63.25 |  | 130431 | 115 |  | 130633 | 2.88
130236 | 17.25 |  | 130433 | 225.4 |  | 130634 | 258.75
130237 | 264.5 |  | 130434 | 209.3 | Span | 130635 | 276 | Span
130238 | 9.2 |  | 130435 | 86.25 | Span | 130636 | 894.7
130239 | 40.25 |  | 130436 | 20.99 | Span | 130637 | 900 | Span
130240 | 67.56 | Span | 130437 | 3.45 |  | 130638 | 20.7
130241 | 120.75 |  | 130439 | 57.5 |  | 130639 | 196.65 | Span
130242 | 9.2 |  | 130440 | 25.3 | Span | 130640 | 34.5
130243 | 2.88 |  | 130441 | 115 |  | 130641 | 113.28
130244 | 350.75 |  | 130442 | 64.4 |  | 130642 | 323.15
130245 | 86.25 |  | 130443 | 195.5 | Span 96 sr | 130643 | 28.75 | Span
130247 | 29.9 |  | 130444 | 161 |  | 130644 | 599.73 | Span
130248 | 616.4 |  | 130445 | 276 |  | 130645 | 20.7
130249 | 5.75 | Span | 130446 | 144.9 |  | 130646 | 4.03
130250 | 391 |  | 130447 | 906.2 |  | 130647 | 25.87 | Span
130251 | 149.5 |  | 130448 | 2313.8 |  | 130648 | 223.1
130252 | 312.8 |  | 130449 | 44.85 | Span | 130649 | 165.6 | Span
130253 | 310.5 |  | 130450 | 67.85 |  | 130650 | 63.25
130255 | 18.4 |  | 130451 | 20.7 | Span | 130651 | 136.85
130256 | 34.5 |  | 130452 | 35.08 | Span | 130652 | 1260.4 | Span
130257 | 6.61 |  | 130453 | 304.75 |  | 130653 | 40.25
130259 | 8.05 |  | 130454 | 3300.5 | Span | 130654 | 39.1
130260 | 115 |  | 130456 | 129.95 | Span | 130657 | 44.56
130261 | 28.75 |  | 130457 | 46 | Span | 130659 | 31.62
130262 | 48.3 |  | 130458 | 57.5 |  | 130660 | 41.4
130263 | 315.1 |  | 130459 | 87.4 | Span | 130661 | 63.82
130264 | 82.8 | Span | 130460 | 11.5 |  | 130662 | 63.83
130265 | 126.5 |  | 130462 | 60.95 |  | 130663 | 368 | Span 300sr
130266 | 2200 |  | 130463 | 273.7 |  | 130664 | 13.8
130267 | 82.8 |  | 130464 | 29.32 |  | 130665 | 499.1 | Span
130268 | 322 | Span | 130465 | 24.15 |  | 130668 | 303.6
130270 | 48.3 |  | 130466 | 39.1 | Span | 130669 | 745.2
130271 | 6.9 |  | 130467 | 46 |  | 130671 | 143.75 | Span
130272 | 11.5 | Span | 130468 | 433.55 |  | 130672 | 63.25
130273 | 11.5 | Span | 130469 | 95.45 |  | 130673 | 27.6
130274 | 153.53 |  | 130470 | 37.95 |  | 130674 | 16.1
130275 | 41.4 |  | 130471 | 193.78 |  | 130675 | 97.75
130276 | 150.65 |  | 130472 | 82.8 | Span | 130677 | 11.5
130277 | 131.1 |  | 130473 | 258.75 |  | 130678 | 50.02 | Span
130278 | 11.5 |  | 130474 | 255.3 |  | 130679 | 28.75
130279 | 14.66 | Span | 130475 | 54.05 | Span | 130680 | 23
130280 | 17.25 |  | 130476 | 115 | Span | 130681 | 69
130281 | 159.85 | Span | 130477 | 546.25 |  | 130682 | 230 | Span
130282 | 1069.99 |  | 130478 | 48.3 |  | 130683 | 70.73 | Span
130283 | 234.6 |  | 130479 | 28.75 |  | 130684 | 274.85
130284 | 342.7 |  | 130480 | 500.25 |  | 130685 | 57.5 | Span
130285 | 183.14 |  | 130481 | 60.95 |  | 130686 | 86.25 | Span
130286 | 18.4 |  | 130482 | 115 |  | 130495 | 626.75 | Span
130287 | 201.25 |  | 130483 | 57.5 | Span | 130496 | 44.04
130288 | 218.5 |  | 130485 | 34.5 |  | 130497 | 115
130289 | 127.88 |  | 130486 | 65.55 |  | 130498 | 68.66
130290 | 186.87 |  | 130487 | 1480.05 | Span | 130499 | 50.03 | Span
130291 | 34.5 |  | 130488 | 28.75 |  | 130500 | 90.28 | Span
130292 | 519.8 | Span 300 | 130489 | 11.5 |  | 130501 | 54.05
130293 | 120.18 | Span | 130490 | 35.07 |  | 130502 | 140.3 | Span
130294 | 594.55 | Span | 130491 | 1100.55 | Span | 130503 | 6.9
130295 | 522.1 |  | 130492 | 55.2 |  | 130504 | 215.63 | Span
130296 | 57.5 |  | 130493 | 14.95
130297 | 87.4 |  | 130494 | 58.07