Spreadsheet: 714587d1611303587-return-sums-from-multiple-columns-with-criteria-oct-nov-dec-2020
Sheet: DEC-2020

 |  | DECEMBER-2020
INVOICE | AMOUNT | PAYMENT TYPE | INVOICE | AMOUNT | PAYMENT TYPE | INVOICE | AMOUNT | PAYMENT TYPE
130688 | 11.5 |  | 130880 | 69 |  | 131075 | 100.05 | Span
130689 | 40.25 |  | 130881 | 70.15 | Span | 131076 | 140.88
130690 | 6.33 |  | 130882 | 538.2 |  | 131077 | 28.75
130691 | 179.98 |  | 130883 | 66.7 |  | 131078 | 24.15
130692 | 11.5 | Span | 130884 | 49.45 | Span | 131079 | 2484 | span 430
130693 | 170.2 | Span | 130885 | 1182.2 |  | 131080 | 3.45
130694 | 11.5 | Span | 130886 | 2070 |  | 131081 | 485.3
130695 | 301.88 |  | 130887 | 253 |  | 131082 | 335.8
130696 | 755.55 |  | 130888 | 322 | Span | 131083 | 80.5
130697 | 340.97 |  | 130889 | 155.25 | Span | 131084 | 218.5
130698 | 736 | Span | 130890 | 25.88 | Span | 131085 | 87.4
130699 | 1691.65 | span 1900 | 130891 | 210.45 |  | 131087 | 255.3
130700 | 37.38 | Span | 130892 | 34.5 |  | 131088 | 14.37
130701 | 226.55 |  | 130894 | 4050.3 | Span | 131089 | 97.75
130702 | 46 |  | 130895 | 186.3 |  | 131090 | 95.45
130703 | 4.03 |  | 130896 | 14.95 |  | 131092 | 149.5
130704 | 105.23 | Span | 130897 | 345 | Span | 131093 | 26.45
130705 | 172.5 |  | 130898 | 10.35 | Span | 131094 | 85.1
130706 | 18.4 |  | 130899 | 115 |  | 131095 | 785.45
130708 | 57.5 |  | 130900 | 202.4 |  | 131096 | 6309.48 | Span
130709 | 158.7 |  | 130901 | 207 |  | 131097 | 28.75 | Span
130710 | 28.75 |  | 130902 | 93.15 |  | 131098 | 51.75
130711 | 4171.97 | Bank Transf | 130903 | 51.75 | Span | 131099 | 241.5 | Span
130712 | 264.5 | Span | 130904 | 139.73 |  | 131100 | 493.93 | Span 380
130713 | 112.7 |  | 130905 | 28.75 |  | 131101 | 510.6
130714 | 70.15 | Span | 130906 | 108.1 |  | 131102 | 12.65
130715 | 90.85 | Span | 130907 | 770.5 |  | 131103 | 28.75
130716 | 234.6 |  | 130908 | 251.85 |  | 131104 | 85.1 | Span
130717 | 425.5 |  | 130909 | 46 |  | 131105 | 155.25 | Span
130718 | 18.4 |  | 130910 | 100.05 | Span | 131106 | 28.75 | Span
130719 | 95.45 | Span | 130911 | 120.75 | Span | 131107 | 3.45 | Span
130720 | 13.8 |  | 130912 | 10.35 | Span | 131108 | 166.18 | Span
130721 | 3.45 |  | 130913 | 79.92 | Span | 131109 | 304.75
130722 | 300.15 |  | 130914 | 414 |  | 131110 | 5.75
130723 | 41.4 |  | 130916 | 2155.68 |  | 131113 | 17.83
130724 | 29.9 | Span | 130917 | 10.35 |  | 131114 | 6.9
130725 | 500.25 |  | 130918 | 143.75 |  | 131115 | 120.18
130726 | 4000.51 |  | 130919 | 5.75 |  | 131116 | 1497.3
130727 | 43.13 |  | 130920 | 78.2 |  | 131117 | 4.6
130729 | 37.95 | Span | 130921 | 129.95 | Span | 131118 | 1090.2
130730 | 52.9 |  | 130922 | 46 |  | 131119 | 759
130731 | 78.2 |  | 130924 | 60.95 |  | 131120 | 1725 | Span
130732 | 27.6 |  | 130925 | 179.4 |  | 131121 | 11.5 | Span
130733 | 74.75 | Span 100 | 130926 | 14.95 | Span | 131122 | 1200.03
130734 | 28.75 | Span | 130927 | 40.25 |  | 131123 | 189.75
130735 | 9.2 | Span | 130928 | 18.97 | Span | 131124 | 220.23
130736 | 9.2 | Span | 130929 | 128.8 |  | 131125 | 10.35
130737 | 215.05 |  | 130930 | 52.9 |  | 131126 | 50.02 | Span
130738 | 25.3 |  | 130931 | 24.15 |  | 131127 | 110.4
130739 | 57.5 |  | 130932 | 149.5 | Span | 131128 | 55.2
130740 | 11.5 |  | 130933 | 2507 |  | 131129 | 506
130741 | 40.25 | Span | 130934 | 69 |  | 131130 | 1926.25 | Span
130742 | 9.2 |  | 130935 | 350.75 | Span | 131131 | 1217.28
130743 | 120.75 |  | 130936 | 432.4 |  | 131132 | 690
130744 | 200.1 |  | 130937 | 805 |  | 131134 | 941.85 | Span
130746 | 87.4 |  | 130938 | 875.15 | Span 670 | 131135 | 255.3 | Span
130747 | 80.5 |  | 130939 | 23 |  | 131136 | 538.2
130748 | 75.9 |  | 130940 | 1099.4 | Span | 131137 | 182.56
130749 | 70.15 | Span | 130941 | 57.5 |  | 131138 | 14.38
130750 | 900 | Span | 130943 | 23 |  | 131139 | 1068.35
130751 | 23 | Span | 130944 | 500.25 |  | 131140 | 24.15
130752 | 396.75 |  | 130945 | 28.75 | Span | 131142 | 520.15 | Span
130753 | 248.4 |  | 130946 | 224.25 |  | 131143 | 400.2
130755 | 127.65 |  | 130947 | 299 |  | 131144 | 145.48 | Span
130756 | 58.65 | Span | 130948 | 98.9 |  | 131145 | 220.8
130757 | 71.3 |  | 130949 | 103.5 |  | 131146 | 793.5 | Span 293.sr
130758 | 25.01 |  | 130950 | 379.5 | Span | 131147 | 92 | span 7.sr
130759 | 258.75 |  | 130951 | 32.2 |  | 131148 | 18.4 | Span
130760 | 1850.93 | Span | 130952 | 57.5 | Span | 131149 | 23
130761 | 138.57 |  | 130953 | 828 |  | 131150 | 180.55 | Span
130762 | 227.99 |  | 130954 | 21.85 |  | 131151 | 795.22 | Span
130763 | 8.05 |  | 130955 | 517.5 |  | 131152 | 18.4
130764 | 900 | Span | 130956 | 115 |  | 131153 | 184 | Span
130766 | 10.35 |  | 130957 | 287.5 |  | 131154 | 16.1 | Span
130767 | 126.5 | Span | 130958 | 630.78 | Span | 131155 | 5.75 | Span
130768 | 81.65 |  | 130959 | 358.8 | span 200 | 131156 | 49.45 | Span
130769 | 316.25 | Span | 130960 | 17.25 |  | 131157 | 92 | Span
130770 | 39.1 | Span | 130961 | 23 |  | 131158 | 25.3 | Span
130771 | 517.5 | Span | 130963 | 9.2 |  | 131159 | 120.75
130772 | 577.88 |  | 130964 | 230 |  | 131160 | 37.95 | Span
130773 | 391 |  | 130965 | 23 |  | 131161 | 1593.33 | Bank Trnsf
130774 | 94.99 |  | 130966 | 258.75 |  | 131162 | 350.75 | Span
130775 | 189.75 |  | 130967 | 379.5 |  | 131163 | 80.73 | Span
130776 | 205.85 |  | 130968 | 359.95 | Span | 131164 | 30.47 | Span
130777 | 696.9 |  | 130969 | 287.5 |  | 131165 | 231.15
130778 | 112.7 |  | 130970 | 12.65 |  | 131166 | 86.25
130779 | 103.5 |  | 130971 | 28.75 |  | 131167 | 350.75 | Span
130780 | 29.9 |  | 130972 | 2550.7 |  | 131168 | 100.05
130781 | 389.27 |  | 130973 | 28.75 |  | 131169 | 387.55
130782 | 230 |  | 130974 | 90.85 |  | 131170 | 142.6
130783 | 109.25 |  | 130975 | 52.9 | Span | 131172 | 259.9 | Span
130785 | 92 | Span | 130976 | 26.45 |  | 131173 | 278.3
130786 | 195.5 |  | 130977 | 55.2 |  | 131174 | 6900
130787 | 220.8 | Span | 130978 | 185.15 | Span | 131175 | 43.7 | Span
130788 | 199.52 |  | 130979 | 11.5 |  | 131176 | 5.46
130789 | 57.5 |  | 130980 | 1500.15 |  | 131177 | 168.19
130790 | 60.78 |  | 130981 | 12.65 |  | 131178 | 280.6 | Span
130791 | 60.38 |  | 130983 | 644 |  | 131179 | 115
130792 | 178.25 |  | 130984 | 100.05 |  | 131180 | 400.2
130793 | 4655.43 |  | 130985 | 89.7 |  | 131181 | 115
130794 | 300.15 | Span | 130986 | 538.2 |  | 131182 | 69
130795 | 23 |  | 130988 | 218.5 |  | 131183 | 80.5 | Span
130796 | 41.4 |  | 130989 | 245.76 |  | 131184 | 270.25
130797 | 115 | Span | 130990 | 138 |  | 131185 | 274.85 | Span
130799 | 381.8 |  | 130991 | 32.2 | Span | 131186 | 498.53 | Span
130800 | 9.2 |  | 130992 | 106.95 |  | 131187 | 24.15 | Span
130801 | 6.9 |  | 130993 | 92 |  | 131188 | 96.6
130802 | 9.2 |  | 130994 | 27.6 |  | 131189 | 432.98
130803 | 24.72 |  | 130995 | 31.05 | Span | 131191 | 63.25
130804 | 110.4 |  | 130996 | 25.3 |  | 131192 | 299 | Span
130805 | 405.95 | Span | 130997 | 202.4 |  | 131193 | 940.7
130806 | 660.1 |  | 130998 | 391 |  | 131194 | 23
130807 | 128.8 |  | 131000 | 70.15 |  | 131196 | 43.7
130808 | 340.4 | Span | 131001 | 56.35 |  | 131197 | 694.6 | Span 459.sr
130809 | 147.2 |  | 131002 | 840.65 | Span | 131198 | 28.75
130810 | 207 | Span | 131003 | 1110.9 | Span | 131199 | 11.5
130811 | 1173 | Bank Transf | 131004 | 400.2 | Span | 131200 | 690
130812 | 264.5 |  | 131005 | 34.5 |  | 131201 | 110.4 | Span
130813 | 112.7 |  | 131006 | 50.6 | Span | 131202 | 1380
130814 | 73.6 |  | 131007 | 7417.5 | Bank Transfer | 131203 | 8.45 | Span
130815 | 240.06 |  | 131009 | 57.5 | Span | 131204 | 55.2
130818 | 109.25 |  | 131008 | 69 | Span | 131205 | 1169.55 | Span
130819 | 92 |  | 131011 | 11.5 |  | 131206 | 2242.5
130822 | 15.35 |  | 131012 | 97.95 |  | 131207 | 149.5
130823 | 29.9 | Span | 131013 | 370.3 | Span | 131208 | 1265 | Span
130824 | 949.9 | Span | 131015 | 209.88 | Span | 131209 | 17.25
130825 | 51.75 |  | 131016 | 977.5 |  | 131210 | 251.85 | Span
130826 | 480.13 |  | 131017 | 348.45 | Span | 131212 | 90.27 | Span
130827 | 67.28 |  | 131018 | 73.6 | Span | 131213 | 115
130828 | 4.6 |  | 131020 | 740.6 |  | 131214 | 3220 | Bank Trnsf
130829 | 258.25 |  | 131022 | 170.2 | Span | 131215 | 840.07
130830 | 200.1 |  | 131023 | 126.5 |  | 131216 | 6.9
130831 | 61.53 |  | 131024 | 230 |  | 131217 | 188.6 | Span
130832 | 74.75 | Span | 131025 | 80.05 |  | 131218 | 57.5
130833 | 25.3 |  | 131026 | 46 |  | 131219 | 149.5 | Span
130834 | 183.71 |  | 131027 | 368 |  | 131220 | 192.8
130835 | 607.2 |  | 131028 | 37.95 | Span | 131221 | 276 | Span
130836 | 10.35 |  | 131029 | 11.5 |  | 131222 | 325.45
130837 | 25.88 |  | 131030 | 23 |  | 131224 | 815.35
130838 | 165.6 |  | 131031 | 7840.7 | Span | 131225 | 1955
130839 | 460 |  | 131032 | 149.5 |  | 131226 | 125.35 | Span
130840 | 210.45 |  | 131033 | 320.85 |  | 131227 | 190.33 | Span
130842 | 13.8 | Span | 131034 | 55.2 | Span | 131228 | 5.75 | Span
130843 | 28.75 |  | 131035 | 488.75 |  | 131231 | 90.85
130844 | 57.5 |  | 131036 | 70.15 |  | 131232 | 63.25
130845 | 40.25 |  | 131037 | 156.4 |  | 131233 | 184
130846 | 489.9 | Span | 131038 | 143.75 |  | 131234 | 218.5 | Span
130847 | 28.75 |  | 131039 | 57.5 |  | 131235 | 42.55 | Span
130848 | 1782.5 |  | 131040 | 208.15 | Span | 131236 | 236.9 | Span
130849 | 284.05 |  | 131041 | 308.2 |  | 131238 | 23 | Span
130850 | 11.5 |  | 131042 | 572.13 | Span | 131239 | 250.7 | Span
130851 | 161 | Span | 131043 | 143.75 |  | 131240 | 34.5
130852 | 74.75 |  | 131044 | 6.9 | Span | 131241 | 227.7
130853 | 120.75 | Span | 131045 | 64.4 |  | 131242 | 230
130854 | 25.3 | Span | 131046 | 29.9 |  | 131243 | 170.2
130855 | 110.4 |  | 131048 | 233.45 | Span | 131244 | 11.5
130856 | 281.75 |  | 131049 | 178.25 | Span | 131245 | 255.3
130857 | 6086.95 | Span 4545 | 131050 | 58.65 |  | 131246 | 72.45
130858 | 184 |  | 131051 | 27.6 |  | 131247 | 186.3 | Span
130859 | 2070 |  | 131052 | 40.25 |  | 131248 | 174.8
130860 | 23 | Span | 131053 | 140.3 |  | 131249 | 207
130861 | 195.5 |  | 131054 | 161 |  | 131250 | 46 | Span
130863 | 57.5 |  | 131055 | 34.5 | Span | 131251 | 17.25 | Span
130864 | 20.7 | Span | 131056 | 198.95 |  | 131252 | 418.03
130865 | 42.56 |  | 131058 | 1197.72 |  | 131253 | 79.92
130866 | 265.08 | Span | 131059 | 230 |  | 131254 | 90.27 | Span
130867 | 13.8 | Span | 131060 | 34.5 |  | 131256 | 16.1 | Span
130868 | 700.35 | Span | 131061 | 155.25 |  | 131257 | 21.85 | Span
130869 | 347.3 |  | 131062 | 115 | Span | 131258 | 318.55 | Span
130870 | 142.6 |  | 131063 | 99.99 | Span | 131259 | 128.8 | Span
130871 | 17.82 |  | 131064 | 10.35 |  | 131260 | 27.6 | Span
130872 | 115 |  | 131065 | 230 |  | 131261 | 270.25
130873 | 250.7 | Span | 131066 | 201.25 |  | 131262 | 11.5 | Span
130874 | 69 |  | 131067 | 133.98 |  | 131263 | 910.8 | Span
130875 | 58.65 |  | 131069 | 41.4 | Span | 131264 | 460
130876 | 5.75 |  | 131070 | 23 |  | 131265 | 29.9 | Span
130877 | 1926.25 | Span | 131071 | 230 |  | 131266 | 4.03
130878 | 248.4 |  | 131073 | 500.25 |  | 131267 | 24.15 | Span
130879 | 2587.5 |  | 131074 | 118.45 |  | 131268 | 5.75
131281 | 355.35 |  | 131290 | 180.55 |  | 131269 | 79.35
131282 | 48.88 | Span 18 sr | 131291 | 430.1 | Span | 131270 | 80.5
131283 | 80.5 |  | 131292 | 850 | Span | 131271 | 60.95
131284 | 69 | Span 18 sr | 131293 | 900.45 | Span | 131272 | 83.95 | Span
131285 | 850 | Span | 131294 | 69 |  | 131273 | 69 | Span
131286 | 259.9 | Span | 131295 | 762.45 |  | 131274 | 50.6 | Span
131287 | 40.25 | Span |  |  |  | 131275 | 11.5 | Span
131288 | 34.5 | Span |  |  |  | 131276 | 23
131289 | 62.1 |  |  |  |  | 131277 | 850 | Span
 |  |  |  |  |  | 131278 | 17.25
 |  |  |  |  |  | 131279 | 404.8 | Span 575.sr