Spreadsheet: 789334d1659039224-sumif-returning-value-once-1a-atlantic-may-fuel-month-end-inventory-test
Sheet: December WTA

Account Number* | Amount*  Dr / (Cr)
20230.15100.001 | -0.03
20260.15100.001 | -0.220000000000027
20350.15100.003 | -0.02
20350.15100.001 | 0.11999999999999
20350.15150.001 | 0.350000000000006
20820.15100.003 | -355.17
20960.15150.001 | -91.34
20965.15150.001 | -287.25
21105.15100.003 | 0.329999999999545
21105.15100.001 | -68.36355000000003
21110.15100.003 | 0.00999999999999091
21115.15100.003 | 0.09
21115.15150.002 | -0.06
21135.15100.003 | 0.579999999999927
21305.15100.001 | -0.03
21305.15150.001 | -0.21
21320.15100.001 | 0.18
21320.15150.001 | 0.38
21325.15150.001 | 0.13
21505.15150.002 | -0.09
21510.15150.002 | 0.01
21515.15150.002 | 0.13
21520.15100.003 | 0.1008000000000493
21605.15150.001 | -82.97
21705.15100.001 | -1.51
21705.15100.003 | 1.20999999999913
21820.15100.001 | 0.2
21820.15150.001 | 0.86
21820.15100.003 | -0.38
21850.15150.001 | -0.4
22175.15100.001 | 5.62
22175.15100.003 | -0.01
22205.15100.001 | -694.44
22310.15150.002 | -0.07
22325.15150.002 | -0.02
22368.15100.001 | -0.08
22368.15100.002 | 0.04
22368.15150.001 | 0.02
22369.15100.001 | -0.27
22369.15100.002 | -0.12
22369.15150.001 | -0.53
22510.15100.001 | 0.03
22510.15150.001 | -0.24
22555.15150.001 | 9.07
22555.15100.001 | 0.04
22625.15100.001 | -56.12
22625.15150.001 | -0.03
22630.15100.001 | -0.5
22630.15150.001 | 7.25
22640.15100.003 | -0.06
22640.15150.001 | 1.48
22640.15100.001 | -0.61
22815.15100.001 | 0.1040600000009704
22826.15100.001 | 236.88
22827.15100.001 | -0.42
22827.15150.001 | 0.38
20021.15100.001 | 121.4274000000078
20022.15100.001 | 0.007699999998294516
20023.15150.002 | -0.8906000000024505
20023.15100.001 | -700.7379599999986
20041.15100.001 | -299.3677999999964
20042.15100.001 | 0.7570000000014261
20215.15100.003 | -0.140519999999924
20215.15100.001 | -74.14280000000053
20215.15150.001 | 151.3097600000001
20215.15150.002 | -3.480569999999716
20220.15150.001 | -47.41212000000087
20220.15150.002 | 29.07020000000193
20225.15150.002 | 40.77386000000115
20225.15150.001 | 271.461650000012
20230.15150.001 | -224.7466400000048
20230.15150.002 | 1.649149999997462
20250.15100.003 | 0.009500000000116415
20250.15100.001 | 37.21140000000014
20250.15150.002 | 110.4374800000078
20260.15150.002 | 166.5940999999875
20265.15150.001 | -18.06505000000107
20265.15100.001 | -23.66287000000011
20265.15150.002 | -611.9242999999988
20310.15150.001 | 26.72600000000057
20320.15100.001 | 0.7546210000000428
20320.15150.001 | -208.3929800000005
20360.15100.001 | 63.71376000000055
20710.15150.002 | -0.9
20710.15150.001 | -0.46
20940.15100.001 | 1.12000000000262
21110.15150.001 | -823.1989600000234
21110.15100.001 | -64.39602999999988
21110.15150.002 | -0.0100000000021827
21115.15100.001 | -0.790000000000455
21125.15100.003 | 0.01
21125.15150.001 | -222.1180899999999
21125.15150.002 | -63.56998000000021
21130.15100.003 | 1.070200000001932
21135.15150.002 | -0.43
21135.15100.001 | 1.39000000000114
21140.15100.001 | 75.16280000000006
21140.15100.003 | 1.656299999998737
21140.15150.001 | 267.0231799999965
21315.15150.001 | 193.2376000000004
21315.15100.001 | 486.0790000000015
21505.15100.003 | -0.8420000000101027
21510.15150.001 | 302.9632000000001
21510.15100.001 | -14.39476000000502
21520.15150.002 | 0.409999999999968
21605.15100.001 | 0.005999999999858119
21610.15150.001 | 0.01
21625.15150.001 | 138.3227000000006
21625.15100.001 | 256.0148399999998
21830.15100.001 | -763.85
22110.15100.001 | 22.81725000000006
22115.15100.001 | 0.290000000007276
22115.15100.003 | -0.14
22115.15100.002 | -60.1597999999999
22115.15150.001 | 529.4449500000046
22119.15100.001 | -0.768500000000131
22119.15100.002 | 0.1616000000012718
22135.15100.001 | -129.2716
22135.15150.001 | 83.64180000000124
22215.15150.001 | 487.5557000000008
22215.15100.001 | 198.1634000000004
22267.15100.001 | 131.0490000000009
22267.15100.003 | 19.41629999999986
22305.15100.001 | -0.02589999999690917
22310.15100.001 | -3.984199999977136
22310.15100.002 | -0.4096000000008644
22310.15150.001 | 0.4799800000619143
22315.15100.002 | 471.9525000000031
22315.15150.002 | -6.190399999999499
22325.15150.001 | 45.47430000000077
22330.15100.002 | 2.35000000000273
22330.15150.002 | 0.1580200000025798
22340.15100.002 | -3.095559999994293
22340.15150.002 | 1.302389999999832
22340.15150.001 | -140.480230000001
22350.15100.002 | -116.4011000000028
22350.15100.001 | -509.2437000000064
22350.15150.002 | -0.0100000000001137
22350.15150.001 | 475.9522099999886
22360.15100.001 | 228.4405999999944
22360.15100.003 | -253.8796999999977
22360.15100.002 | -1.011999999998807
22360.15150.001 | -15.53160000001662
22363.15100.001 | 149.648000000001
22363.15100.002 | -0.8690000000005966
22364.15100.002 | 10.24584400000094
22364.15150.001 | -45.12065000000075
22365.15100.001 | 658.0835499999994
22365.15150.001 | -114.0862000000006
22367.15100.001 | -229.0171999999984
22367.15150.001 | 127.0410000000011
22367.15100.002 | 46.72010000000046
22370.15100.002 | -0.3060000000004948
22370.15150.001 | 0.7700000000004366
22373.15100.001 | -342.5102000000006
22373.15150.001 | 74.46999999999389
22420.15100.003 | 0.0100000000004547
22420.15100.001 | 0.629999999998181
22433.15150.001 | -0.4706600000008621
22435.15100.001 | -5.749600000010105
22436.15100.001 | -0.4127500000013242
22436.15150.001 | -0.5021299999934854
22437.15150.001 | -2.164849999986473
22437.15100.001 | 62.22817000000214
22438.15100.001 | -0.2371099999982107
22438.15150.001 | -0.6684199999872362
22445.15100.001 | -0.2813000000023749
22450.15100.003 | 0.02439999999842257
22450.15100.001 | 3.696200000005774
22505.15150.001 | 640.2619670000058
22515.15100.001 | 5.673650000000634
22515.15150.001 | 91.24854599999526
22540.15100.001 | -0.3636920000008104
22560.15150.001 | -3.348700000002282
22560.15100.001 | 0.4923000000017055
22571.15150.001 | -14.36290999996709
22572.15100.001 | 51.66135999999824
22573.15100.001 | -7.670339999998959
22573.15150.001 | -43.16618000000744
22575.15100.001 | 0.3535000000001673
22575.15150.001 | -0.3319999999985157
22585.15100.001 | 17.95428999999967
22590.15100.001 | 60.22293600000012
22590.15150.001 | -524.6914969999998
22600.15150.001 | 474.6252000000022
22605.15100.001 | 0.4445849999974598
22605.15150.001 | -3.515151999992668
22615.15150.001 | 0.01200000000244472
22615.15100.001 | -22.60600000000022
22630.15100.003 | -0.09
22635.15100.001 | -0.03399999999783176
22635.15150.001 | -2.655500000008033
22655.15100.001 | 0.1671900000001187
22705.15100.001 | 649.7750999999989
22790.15150.001 | -2.672967999998946
22795.15100.001 | -2.434615000001941
22795.15150.001 | 0.2411099999990256
22810.15150.002 | 2.82000000000045
22825.15100.001 | -25.21710000000166
22825.15150.001 | -776.3042599999753
20210.15100.003 | -10.21
20815.15100.001 | -0.03606999999988147
20950.15150.002 | -0.41
21505.15100.004 | 2.4
21800.15100.001 | -0.02
22110.15100.003 | -0.03606999999995075
22175.15150.001 | 0.34
22705.15150.002 | -1.97
20022.15150.001 | 0.007959999988088384
20023.15100.004 | -0.02440000000024156
20041.15150.001 | -274.2333999999973
20042.15150.001 | -22.2013999999981
20220.15100.001 | -2.94000000000091
20230.15100.003 | -0.05
20240.15100.001 | -625.3213199999991
20245.15150.001 | -670.1277000000118
20270.15150.002 | -109.3945239999957
20330.15100.001 | 0.9871099999991202
20330.15150.001 | 347.5841599999985
20365.15100.001 | 71.64744000000064
20365.15150.001 | -50.95532000000094
20825.15150.001 | -1.976821999996901
20940.15100.003 | 0.94
21105.15150.002 | -0.09
21115.15150.001 | -24.20154999999977
21130.15150.002 | 303.3883599999972
21140.15150.002 | 913.89761
21515.15100.001 | 0.01
21530.15100.001 | -0.9457199999997101
21800.15100.003 | -0.05
22326.15150.001 | 207.299439999988
22326.15100.002 | -139.006159999999
22350.15100.003 | -0.7760000000052969
22374.15100.002 | 0.02
22425.15100.003 | 0.01
22430.15100.001 | 0.00999999999839929
22457.15100.001 | 1.4900000000016
22572.15150.001 | -1.358980000019073
22705.15150.001 | 118.1996199999703
22710.15150.001 | 2.808409999997821
22790.15100.001 | 278.265946999999
22810.15100.001 | 0.007200000000011642
22156.15150.001 | 343.8421600000038
22156.15100.001 | 108.02592
20230.60111.102 | 0.03
20260.60111.102 | 0.220000000000027
20350.60113.102 | 0.02
20350.60111.102 | -0.11999999999999
20350.60121.102 | -0.350000000000006
20820.60113.102 | 355.17
20960.60121.102 | 91.34
20965.60121.102 | 287.25
21105.60113.102 | -0.329999999999545
21105.60111.102 | 68.36355000000003
21110.60113.102 | -0.00999999999999091
21115.60113.102 | -0.09
21115.60122.102 | 0.06
21135.60113.102 | -0.579999999999927
21305.60111.102 | 0.03
21305.60121.102 | 0.21
21320.60111.102 | -0.18
21320.60121.102 | -0.38
21325.60121.102 | -0.13
21505.60122.102 | 0.09
21510.60122.102 | -0.01
21515.60122.102 | -0.13
21520.60113.102 | -0.1008000000000493
21605.60121.102 | 82.97
21705.60111.102 | 1.51
21705.60113.102 | -1.20999999999913
21820.60111.102 | -0.2
21820.60121.102 | -0.86
21820.60113.102 | 0.38
21850.60121.102 | 0.4
22175.60111.102 | -5.62
22175.60113.102 | 0.01
22205.60111.102 | 694.44
22310.60122.102 | 0.07
22325.60122.102 | 0.02
22368.60111.102 | 0.08
22368.60112.102 | -0.04
22368.60121.102 | -0.02
22369.60111.102 | 0.27
22369.60112.102 | 0.12
22369.60121.102 | 0.53
22510.60111.102 | -0.03
22510.60121.102 | 0.24
22555.60121.102 | -9.07
22555.60111.102 | -0.04
22625.60111.102 | 56.12
22625.60121.102 | 0.03
22630.60111.102 | 0.5
22630.60121.102 | -7.25
22640.60113.102 | 0.06
22640.60121.102 | -1.48
22640.60111.102 | 0.61
22815.60111.102 | -0.1040600000009704
22826.60111.102 | -236.88
22827.60111.102 | 0.42
22827.60121.102 | -0.38
20021.60111.102 | -121.4274000000078
20022.60111.102 | -0.007699999998294516
20023.60122.102 | 0.8906000000024505
20023.60111.102 | 700.7379599999986
20041.60111.102 | 299.3677999999964
20042.60111.102 | -0.7570000000014261
20215.60113.102 | 0.140519999999924
20215.60111.102 | 74.14280000000053
20215.60121.102 | -151.3097600000001
20215.60122.102 | 3.480569999999716
20220.60121.102 | 47.41212000000087
20220.60122.102 | -29.07020000000193
20225.60122.102 | -40.77386000000115
20225.60121.102 | -271.461650000012
20230.60121.102 | 224.7466400000048
20230.60122.102 | -1.649149999997462
20250.60113.102 | -0.009500000000116415
20250.60111.102 | -37.21140000000014
20250.60122.102 | -110.4374800000078
20260.60122.102 | -166.5940999999875
20265.60121.102 | 18.06505000000107
20265.60111.102 | 23.66287000000011
20265.60122.102 | 611.9242999999988
20310.60121.102 | -26.72600000000057
20320.60111.102 | -0.7546210000000428
20320.60121.102 | 208.3929800000005
20360.60111.102 | -63.71376000000055
20710.60122.102 | 0.9
20710.60121.102 | 0.46
20940.60111.102 | -1.12000000000262
21110.60121.102 | 823.1989600000234
21110.60111.102 | 64.39602999999988
21110.60122.102 | 0.0100000000021827
21115.60111.102 | 0.790000000000455
21125.60113.102 | -0.01
21125.60121.102 | 222.1180899999999
21125.60122.102 | 63.56998000000021
21130.60113.102 | -1.070200000001932
21135.60122.102 | 0.43
21135.60111.102 | -1.39000000000114
21140.60111.102 | -75.16280000000006
21140.60113.102 | -1.656299999998737
21140.60121.102 | -267.0231799999965
21315.60121.102 | -193.2376000000004
21315.60111.102 | -486.0790000000015
21505.60113.102 | 0.8420000000101027
21510.60121.102 | -302.9632000000001
21510.60111.102 | 14.39476000000502
21520.60122.102 | -0.409999999999968
21605.60111.102 | -0.005999999999858119
21610.60121.102 | -0.01
21625.60121.102 | -138.3227000000006
21625.60111.102 | -256.0148399999998
21830.60111.102 | 763.85
22110.60111.102 | -22.81725000000006
22115.60111.102 | -0.290000000007276
22115.60113.102 | 0.14
22115.60112.102 | 60.1597999999999
22115.60121.102 | -529.4449500000046
22119.60111.102 | 0.768500000000131
22119.60112.102 | -0.1616000000012718
22135.60111.102 | 129.2716
22135.60121.102 | -83.64180000000124
22215.60121.102 | -487.5557000000008
22215.60111.102 | -198.1634000000004
22267.60111.102 | -131.0490000000009
22267.60113.102 | -19.41629999999986
22305.60111.102 | 0.02589999999690917
22310.60111.102 | 3.984199999977136
22310.60112.102 | 0.4096000000008644
22310.60121.102 | -0.4799800000619143
22315.60112.102 | -471.9525000000031
22315.60122.102 | 6.190399999999499
22325.60121.102 | -45.47430000000077
22330.60112.102 | -2.35000000000273
22330.60122.102 | -0.1580200000025798
22340.60112.102 | 3.095559999994293
22340.60122.102 | -1.302389999999832
22340.60121.102 | 140.480230000001
22350.60112.102 | 116.4011000000028
22350.60111.102 | 509.2437000000064
22350.60122.102 | 0.0100000000001137
22350.60121.102 | -475.9522099999886
22360.60111.102 | -228.4405999999944
22360.60113.102 | 253.8796999999977
22360.60112.102 | 1.011999999998807
22360.60121.102 | 15.53160000001662
22363.60111.102 | -149.648000000001
22363.60112.102 | 0.8690000000005966
22364.60112.102 | -10.24584400000094
22364.60121.102 | 45.12065000000075
22365.60111.102 | -658.0835499999994
22365.60121.102 | 114.0862000000006
22367.60111.102 | 229.0171999999984
22367.60121.102 | -127.0410000000011
22367.60112.102 | -46.72010000000046
22370.60112.102 | 0.3060000000004948
22370.60121.102 | -0.7700000000004366
22373.60111.102 | 342.5102000000006
22373.60121.102 | -74.46999999999389
22420.60113.102 | -0.0100000000004547
22420.60111.102 | -0.629999999998181
22433.60121.102 | 0.4706600000008621
22435.60111.102 | 5.749600000010105
22436.60111.102 | 0.4127500000013242
22436.60121.102 | 0.5021299999934854
22437.60121.102 | 2.164849999986473
22437.60111.102 | -62.22817000000214
22438.60111.102 | 0.2371099999982107
22438.60121.102 | 0.6684199999872362
22445.60111.102 | 0.2813000000023749
22450.60113.102 | -0.02439999999842257
22450.60111.102 | -3.696200000005774
22505.60121.102 | -640.2619670000058
22515.60111.102 | -5.673650000000634
22515.60121.102 | -91.24854599999526
22540.60111.102 | 0.3636920000008104
22560.60121.102 | 3.348700000002282
22560.60111.102 | -0.4923000000017055
22571.60121.102 | 14.36290999996709
22572.60111.102 | -51.66135999999824
22573.60111.102 | 7.670339999998959
22573.60121.102 | 43.16618000000744
22575.60111.102 | -0.3535000000001673
22575.60121.102 | 0.3319999999985157
22585.60111.102 | -17.95428999999967
22590.60111.102 | -60.22293600000012
22590.60121.102 | 524.6914969999998
22600.60121.102 | -474.6252000000022
22605.60111.102 | -0.4445849999974598
22605.60121.102 | 3.515151999992668
22615.60121.102 | -0.01200000000244472
22615.60111.102 | 22.60600000000022
22630.60113.102 | 0.09
22635.60111.102 | 0.03399999999783176
22635.60121.102 | 2.655500000008033
22655.60111.102 | -0.1671900000001187
22705.60111.102 | -649.7750999999989
22790.60121.102 | 2.672967999998946
22795.60111.102 | 2.434615000001941
22795.60121.102 | -0.2411099999990256
22810.60122.102 | -2.82000000000045
22825.60111.102 | 25.21710000000166
22825.60121.102 | 776.3042599999753
20210.60113.102 | 10.21
20815.60111.102 | 0.03606999999988147
20950.60122.102 | 0.41
21505.60114.102 | -2.4
21800.60111.102 | 0.02
22110.60113.102 | 0.03606999999995075
22175.60121.102 | -0.34
22705.60122.102 | 1.97
20022.60121.102 | -0.007959999988088384
20023.60114.102 | 0.02440000000024156
20041.60121.102 | 274.2333999999973
20042.60121.102 | 22.2013999999981
20220.60111.102 | 2.94000000000091
20230.60113.102 | 0.05
20240.60111.102 | 625.3213199999991
20245.60121.102 | 670.1277000000118
20270.60122.102 | 109.3945239999957
20330.60111.102 | -0.9871099999991202
20330.60121.102 | -347.5841599999985
20365.60111.102 | -71.64744000000064
20365.60121.102 | 50.95532000000094
20825.60121.102 | 1.976821999996901
20940.60113.102 | -0.94
21105.60122.102 | 0.09
21115.60121.102 | 24.20154999999977
21130.60122.102 | -303.3883599999972
21140.60122.102 | -913.89761
21515.60111.102 | -0.01
21530.60111.102 | 0.9457199999997101
21800.60113.102 | 0.05
22326.60121.102 | -207.299439999988
22326.60112.102 | 139.006159999999
22350.60113.102 | 0.7760000000052969
22374.60112.102 | -0.02
22425.60113.102 | -0.01
22430.60111.102 | -0.00999999999839929
22457.60111.102 | -1.4900000000016
22572.60121.102 | 1.358980000019073
22705.60121.102 | -118.1996199999703
22710.60121.102 | -2.808409999997821
22790.60111.102 | -278.265946999999
22810.60111.102 | -0.007200000000011642
22156.60121.102 | -343.8421600000038
22156.60111.102 | -108.02592