Spreadsheet: 714477d1611242027-return-sums-from-multiple-columns-with-criteria-oct-nov-dec-2020
Sheet: OCT-2020

 |  |  | OCTOBER-2020
INVOICE | AMOUNT | PAYMENT TYPE | INVOICE | AMOUNT | PAYMENT TYPE | INVOICE | AMOUNT | PAYMENT TYPE
129503 | 40.25 |  | 129709 | 40.25 |  | 129913 | 199.99
129504 | 18.4 |  | 129710 | 184 | Span | 129914 | 210.45
129505 | 24.72 |  | 129712 | 11.5 |  | 129915 | 170.77
129506 | 448.5 |  | 129713 | 161 |  | 129916 | 12.65
129507 | 80.1 | Span | 129714 | 27.6 |  | 129917 | 632.5
129508 | 86.25 |  | 129715 | 28.75 | Span | 129918 | 155.25 | Span
129509 | 1500 |  | 129716 | 379.5 |  | 129919 | 276
129510 | 180.9 | Span | 129717 | 85.1 |  | 129920 | 9.2 |  |  |  |  | Span
129511 | 386.4 |  | 129718 | 34.5 |  | 129921 | 5.17 |  |  |  |  | Cash
129512 | 19.55 | Span | 129719 | 63.25 |  | 129922 | 161 |  |  |  |  | Bank
129513 | 100.2 | Span | 129720 | 362.25 |  | 129923 | 171.35
129514 | 98.32 | Span | 129721 | 197.8 | Span | 129924 | 300.15 | Span
129515 | 8.05 |  | 129722 | 120.75 | Span | 129925 | 434.7 | Span
129516 | 630 | Span | 129723 | 34.5 |  | 129926 | 172.5
129517 | 36.8 |  | 129724 | 16.1 |  | 129927 | 20.7
129518 | 800 |  | 129725 | 85.1 |  | 129928 | 165.6
129519 | 100.25 |  | 129726 | 657.8 |  | 129929 | 100.05
129520 | 285.2 |  | 129727 | 28.75 |  | 129930 | 5.75 | Span
129521 | 115 |  | 129728 | 1780 |  | 129931 | 75.9 | Span
129523 | 280.4 | Span | 129729 | 40.25 | Span | 129932 | 200.1 | Span
129524 | 62.1 | Span | 129731 | 140.3 |  | 129933 | 20.13
129526 | 220.8 |  | 129732 | 21.85 |  | 129934 | 55.2 | Span
129527 | 954.5 |  | 129733 | 1738.8 | Span | 129935 | 205.85 | Span
129528 | 9.2 |  | 129734 | 63.25 |  | 129936 | 150.65
129529 | 220.75 | Span | 129735 | 395.6 | Span | 129937 | 200
129530 | 210.25 | Span | 129736 | 12.65 | Span | 129938 | 34.5
129532 | 664.99 |  | 129737 | 25.3 |  | 129939 | 17.25
129533 | 100.05 |  | 129738 | 603.75 |  | 129940 | 471.5
129534 | 110.4 | Span | 129739 | 938.98 |  | 129941 | 4.6 | Span
129535 | 970.6 | Span | 129740 | 207 |  | 129942 | 179.98
129536 | 34.5 |  | 129741 | 111.55 |  | 129943 | 115 | Span
129537 | 92 | Span | 129742 | 890.56 | Span | 129945 | 185.15
129538 | 365.7 |  | 129743 | 80.5 | Span | 129946 | 8.05
129539 | 9.2 |  | 129744 | 170.2 | Span | 129947 | 24.15
129542 | 100.05 |  | 129745 | 18.4 | Span | 129948 | 210.45 | Span
129543 | 80.5 |  | 129746 | 138 |  | 129949 | 30.48 | Span
129544 | 87.4 |  | 129747 | 69 |  | 129950 | 1999.85 | Bank Transfr
129545 | 243.8 |  | 129748 | 764.75 | Span | 129952 | 12.65
129546 | 13.8 |  | 129750 | 34.5 |  | 129953 | 419.75
129547 | 28.75 |  | 129751 | 27.6 |  | 129954 | 11.5
129548 | 1200.6 | Span | 129752 | 163.3 |  | 129955 | 265.19
129549 | 27.6 |  | 129753 | 89.7 |  | 129956 | 350.17
129551 | 408.25 |  | 129754 | 322 |  | 129957 | 6.33
129552 | 31.05 |  | 129755 | 55.2 |  | 129958 | 14.95 | Span
129553 | 41.4 | Span | 129757 | 143.75 |  | 129959 | 25.3
129554 | 1219 |  | 129758 | 2619.7 | Span | 129960 | 310.5
129555 | 80.21 |  | 129760 | 92 | Span | 129961 | 46.57 | Span
129556 | 97.75 | Span | 129762 | 8.63 | Span | 129962 | 14.95 | Span
129557 | 227.7 | Span | 129764 | 75.9 | Span | 129963 | 42.55
129558 | 516.92 |  | 129765 | 82.8 | Span | 129964 | 5.75
129559 | 17.25 |  | 129766 | 23 | Span | 129965 | 900 | Span
129560 | 212.75 |  | 129767 | 679.08 |  | 129966 | 89.7 | Span
129561 | 34.5 |  | 129768 | 1060.76 | Span | 129967 | 143.75 | Span
129563 | 17.25 |  | 129769 | 59.8 |  | 129968 | 276
129564 | 443.9 |  | 129770 | 210.45 |  | 129969 | 66.7
129566 | 9.2 |  | 129771 | 83.95 | Span | 129971 | 5.75
129569 | 13.8 | Span | 129772 | 552 | Span | 129972 | 150.65
129570 | 80.5 |  | 129773 | 92 | Span | 129973 | 519.8 | Span
129571 | 437 |  | 129774 | 9.2 |  | 129974 | 144.9 | Span
129572 | 1753.75 | Span | 129775 | 46 | Span | 129975 | 96.6
129573 | 180.55 | Span | 129776 | 44.85 |  | 129976 | 281.75 | Span
129574 | 18.4 |  | 129777 | 34.5 | Span | 129977 | 52.9
129575 | 309.35 | Span | 129778 | 59.8 | Span | 129978 | 900 | Span
129576 | 166.75 |  | 129779 | 460 |  | 129979 | 2.88
129577 | 1207.5 |  | 129780 | 86.25 |  | 129980 | 51.75
129578 | 362.25 |  | 129782 | 37.95 | Span | 129981 | 15.53 | Span
129579 | 122.48 |  | 129783 | 12.65 |  | 129982 | 248.4
129580 | 368 |  | 129784 | 110.4 |  | 129983 | 500 | Span
129581 | 1765.25 | Span | 129785 | 425.5 |  | 129984 | 132.25
129583 | 26.45 |  | 129786 | 1314.99 | Span | 129985 | 29.9
129584 | 36.8 |  | 129787 | 58.65 |  | 129986 | 80.5
129585 | 62.1 |  | 129788 | 350.75 | Span | 129987 | 120.75
129586 | 11.5 |  | 129789 | 364.55 |  | 129988 | 347.3
129587 | 90.27 |  | 129790 | 230 |  | 129989 | 4348.15
129588 | 23 |  | 129791 | 11.5 |  | 129990 | 149.5 | Span
129589 | 20.7 |  | 129792 | 40.25 |  | 129991 | 517.5
129590 | 55.2 | Span | 129793 | 69 |  | 129992 | 126.5
129591 | 110.4 |  | 129794 | 27.6 |  | 129993 | 92
129592 | 161 |  | 129795 | 40.25 |  | 129994 | 92
129593 | 700.35 |  | 129796 | 169.05 | Span | 129996 | 698.05
129594 | 43.7 |  | 129798 | 172.5 | Span | 129997 | 19.55 | Span
129595 | 4.6 |  | 129799 | 348.45 | Span | 129998 | 319.7
129596 | 29.9 |  | 129800 | 1000.01 | Span | 129999 | 12.08
129598 | 46 | Span | 129801 | 93.15 |  | 130000 | 316.25 | Span
129599 | 18.97 | Span | 129802 | 46 |  | 130001 | 287.5
129600 | 115 | Span | 129803 | 707.25 | Span | 130002 | 54.05
129601 | 370.3 | Span | 129804 | 26.45 |  | 130003 | 17.25
129602 | 53.47 |  | 129805 | 16.1 |  | 130004 | 1030.4 | Span
129603 | 17.25 |  | 129806 | 13.8 |  | 130005 | 139.72 | Span
129604 | 94.87 | Span | 129807 | 17.25 |  | 130006 | 55.2
129605 | 9.2 |  | 129808 | 147.2 | Span | 130007 | 70.15 | Span
129606 | 34.5 | Span | 129809 | 169.05 |  | 130008 | 82.8
129607 | 75.9 |  | 129810 | 1267.01 |  | 130009 | 103.5
129608 | 34.5 |  | 129811 | 319.7 | Span | 130010 | 82.8
129609 | 900 | Span | 129812 | 46 |  | 130012 | 138 | Span
129610 | 41.4 |  | 129813 | 400.2 |  | 130013 | 978.65
129611 | 19.55 |  | 129814 | 195.5 |  | 130014 | 8.05
129612 | 350.75 | Span | 129816 | 90.85 |  | 130015 | 103.5
129613 | 75.33 | Span | 129817 | 1748 |  | 130016 | 200.1
129614 | 80.5 | Span | 129818 | 103.5 |  | 130017 | 80.5
129615 | 2022.85 | Span 1700 | 129819 | 65.55 | Span | 130019 | 48.3 |  |  |  | 2022.85
129616 | 131.1 |  | 129820 | 754.4 |  | 130020 | 1493.28 | Cheque [NAME]
129617 | 455.4 |  | 129821 | 320.85 | Span | 130021 | 138
129618 | 101.2 |  | 129822 | 200.1 | Span | 130022 | 140.3 | Span
129619 | 35.65 |  | 129823 | 140.3 | Span | 130023 | 276
129620 | 69 |  | 129825 | 14.95 |  | 130025 | 20.7 | Span
129621 | 155.25 | Span | 129826 | 103.5 |  | 130026 | 579.02 | Span
129622 | 138 |  | 129828 | 147.2 |  | 130027 | 58.65
129623 | 250.12 | Span | 129829 | 175.95 |  | 130028 | 50.03 | Span
129624 | 150.07 | Span | 129830 | 203.55 |  | 130029 | 103.5
129626 | 158.7 |  | 129831 | 77.05 |  | 130030 | 13.8
129627 | 54.05 | Span | 129832 | 80.5 |  | 130031 | 13.8
129628 | 3082 |  | 129833 | 432.4 |  | 130032 | 172.5 | Span
129629 | 31.05 | Span | 129835 | 13.8 |  | 130033 | 34.5
129630 | 512.9 | Span | 129836 | 230 | Span | 130034 | 250.7
129631 | 724.5 |  | 129837 | 46 |  | 130035 | 50.02
129632 | 155.25 | Span | 129838 | 129.95 | Span | 130036 | 525
129633 | 86.25 |  | 129839 | 69 |  | 130037 | 220.22
129634 | 178.25 |  | 129840 | 195.5 |  | 130039 | 100.05 | Span
129635 | 63.25 |  | 129841 | 52.9 |  | 130040 | 16.1
129636 | 210.16 | Span | 129842 | 158.13 |  | 130041 | 75.9
129637 | 150.65 | Span | 129843 | 5.75 |  | 130042 | 140.3
129638 | 2426.5 | Span | 129844 | 800.4 |  | 130043 | 28.75 | Span
129640 | 56.35 | Span | 129845 | 3162.5 |  | 130044 | 39.68
129642 | 90.28 | Span | 129846 | 13.8 |  | 130045 | 81.65
129643 | 3786.95 |  | 129847 | 2188.45 |  | 130046 | 75.9
129644 | 9.2 | Span | 129848 | 127.07 |  | 130047 | 24.15
129646 | 377.2 |  | 129849 | 460 |  | 130048 | 92
129647 | 410.55 | Span | 129850 | 143.75 |  | 130049 | 200.1 | Span
129648 | 331.2 |  | 129851 | 250.7 |  | 130050 | 21.85 | Span
129649 | 747.5 |  | 129852 | 34.5 |  | 130051 | 26.45 | Span
129650 | 169.05 |  | 129853 | 43.7 |  | 130052 | 11.5 | Span
129651 | 69 | Span | 129854 | 46 |  | 130053 | 785.45 | Span
129652 | 97.75 |  | 129856 | 1269.6 |  | 130054 | 345
129653 | 43.13 | Span | 129857 | 184 | Span 30 sr | 130055 | 88.55
129654 | 885.5 | Span | 129858 | 10.06 |  | 130056 | 11.5
129655 | 165.6 | Span | 129859 | 5.75 |  | 130057 | 437
129656 | 138 | Span | 129860 | 51.75 |  | 130058 | 1699.7 | Span
129657 | 26.45 | Span | 129861 | 264.5 |  | 130059 | 120.75 | Span
129658 | 4.6 |  | 129862 | 220.8 | Span | 130060 | 10.35
129659 | 52.9 | Span | 129864 | 13.8 |  | 130062 | 23
129660 | 115 |  | 129865 | 51.75 |  | 130063 | 922.88
129661 | 5.75 |  | 129866 | 435.85 | Span | 130064 | 315.05 | Span
129662 | 18.4 |  | 129867 | 66.7 |  | 130065 | 96.6
129663 | 23 | Span | 129868 | 29.9 |  | 130066 | 296.7
129664 | 9.2 |  | 129869 | 144.9 |  | 130067 | 34.5
129666 | 2.3 |  | 129870 | 129.95 |  | 130068 | 39.1
129667 | 3.45 |  | 129871 | 20.7 |  | 130069 | 5.75
129668 | 263.35 |  | 129872 | 149.5 | Span | 130070 | 241.5
129669 | 29.9 | Span | 129873 | 250.7 |  | 130071 | 20.7
129670 | 17.25 |  | 129874 | 319.7 |  | 130072 | 1725 | Span
129671 | 86.25 | Span | 129875 | 13.8 | Span | 130073 | 660.1 | Span
129672 | 25.3 | Span | 129876 | 18.97 | Span | 130074 | 174.8
129673 | 952.2 |  | 129877 | 51.75 |  | 130075 | 25.3
129675 | 80.5 | Span | 129878 | 273.7 |  | 130076 | 931.5
129676 | 264.5 |  | 129879 | 95.16 |  | 130077 | 322
129677 | 135.7 |  | 129880 | 362.25 |  | 130078 | 57.5
129678 | 41.4 |  | 129881 | 57.5 |  | 130079 | 414
129679 | 603.75 |  | 129882 | 900 | Span | 130080 | 1849.99 | Span
129680 | 165.6 | Span | 129883 | 140.3 | Span | 130081 | 330.05
129681 | 373.75 | Span | 129884 | 12.65 |  | 130082 | 80.5
129682 | 19.55 | Span | 129885 | 80.5 |  | 130083 | 57.5
129683 | 26.45 |  | 129886 | 257.6 |  | 130084 | 50
129684 | 359.95 |  | 129887 | 386.4 |  | 130085 | 56.35
129685 | 899.3 |  | 129888 | 120.75 |  | 130087 | 16.1
129686 | 34.5 |  | 129889 | 128.8 |  | 130089 | 51.75
129687 | 234.6 | Span | 129891 | 320.85 | Span | 130090 | 10.35 | Span
129688 | 115 | Span | 129892 | 2070 | Span | 130091 | 2423.05
129689 | 1127 | Span | 127803 | 171.35 |  | 130092 | 289.8 | Span
129690 | 1127 |  | 129894 | 88.55 |  | 130093 | 370.3 | Span
129691 | 175.95 |  | 129895 | 610.65 | Span | 130094 | 487.6 | Span
129692 | 98.9 |  | 129896 | 14.95 | Span | 130095 | 25.3
129693 | 1025.23 |  | 129897 | 9.2 |  | 130096 | 556.6
129694 | 207.58 | Span | 129898 | 72.45 |  | 130097 | 23
129695 | 8.05 | Span | 129899 | 241.5 |  | 130098 | 75.33 | Span
129696 | 2185 | Span | 129900 | 92 |  | 130099 | 1043.05 | Span
129697 | 88.55 | Span | 129901 | 129.95
129698 | 569.02 |  | 129902 | 74.75
129699 | 39.67 |  | 129903 | 23
129700 | 920 |  | 129904 | 86.25
129701 | 1035 | Span | 129905 | 57.5 | Span
129702 | 402.5 |  | 129906 | 21.85
129704 | 73.6 |  | 129907 | 96.6
129705 | 289.8 |  | 129908 | 9.2
129706 | 414.06 |  | 129909 | 28.75
129707 | 170.2 |  | 129910 | 14.95 | Span
 |  |  | 129911 | 110.4
 |  |  |  | 155382