Spreadsheet: 790751d1659976361-sumif-returning-value-once-test-file-forum
Sheet: January WTA

Account Number* | Amount*  Dr / (Cr)
20530.15150.004 | 0.01
20210.15100.001 | 4900.64
20220.15100.001 | 0.01
20230.15100.001 | 0.12
20230.15100.003 | -0.02
20245.15100.001 | -781.78
20260.15100.001 | -0.28
20265.15100.001 | 184.73
20265.15100.003 | 0.13
20350.15100.001 | 21.86
20350.15100.003 | 2.59
20410.15100.001 | -0.06
20510.15100.001 | -0.37
20620.15100.001 | 0.16
20625.15100.001 | 28.06
20810.15100.001 | 31.15
20810.15100.003 | -0.1
25116.15100.001 | 13535.16
25157.15100.001 | 4.45
28048.15100.003 | -57.98
28049.15100.001 | 20.19
20210.15150.001 | 1739.62
20215.15150.002 | 28.93
20220.15150.001 | 10.96
20220.15150.002 | 35.78
20230.15150.001 | 210.12
20230.15150.002 | 325.43
20260.15150.001 | 1780.31
20260.15150.002 | -3.59
20265.15150.002 | 1377.87
20270.15150.001 | 3377.57
20270.15150.002 | 1.47
20350.15150.001 | 1828.94
20510.15150.002 | 360.74
20540.15150.001 | -0.46
20540.15150.002 | -0.4
20610.15150.001 | 6332
20610.15150.002 | 975.63
20615.15150.001 | 20123.76
20615.15150.002 | 3.8
20620.15150.001 | -0.83
20620.15150.002 | -0.16
20625.15150.001 | -0.05
20625.15150.002 | 33.9
20630.15150.001 | -0.33
20630.15150.002 | 1.98
20635.15150.001 | -0.06
20635.15150.002 | -5.68
20640.15150.001 | -65.4
20640.15150.002 | -40.13
20645.15150.001 | -0.04
20645.15150.002 | 16.02
20650.15150.001 | 0.14
20650.15150.002 | 1
20825.15150.001 | -0.3
20910.15150.001 | 0.06
20915.15150.001 | 0.04
20915.15150.002 | 1.94
20940.15150.002 | 198.7
20950.15150.002 | 8.55
20960.15150.001 | 1.8
20965.15150.001 | 22.14
20965.15150.002 | 19.25
25141.15150.002 | -496.11
25150.15150.001 | 984.04
25151.15150.002 | -9.78
25157.15150.001 | -1.4
25160.15150.002 | -101.58
28046.15150.001 | 1.72
28047.15150.001 | 2.92
28049.15150.001 | -1.05
28050.15150.001 | 0.26
28093.15150.001 | -55.38
28094.15150.001 | -1.4
28103.15150.001 | -1.22
20215.15410 | 683.23
20265.15410 | -36.23
20510.15410 | -209.63
20820.15410 | -444.57
20530.60125.102 | -0.01
20210.60111.102 | -4900.64
20220.60111.102 | -0.01
20230.60111.102 | -0.12
20230.60113.102 | 0.02
20245.60111.102 | 781.78
20260.60111.102 | 0.28
20265.60111.102 | -184.73
20265.60113.102 | -0.13
20350.60111.102 | -21.86
20350.60113.102 | -2.59
20410.60111.102 | 0.06
20510.60111.102 | 0.37
20620.60111.102 | -0.16
20625.60111.102 | -28.06
20810.60111.102 | -31.15
20810.60113.102 | 0.1
25116.60111.102 | -13535.16
25157.60111.102 | -4.45
28048.60113.102 | 57.98
28049.60111.102 | -20.19
20210.60121.102 | -1739.62
20215.60122.102 | -28.93
20220.60121.102 | -10.96
20220.60122.102 | -35.78
20230.60121.102 | -210.12
20230.60122.102 | -325.43
20260.60121.102 | -1780.31
20260.60122.102 | 3.59
20265.60122.102 | -1377.87
20270.60121.102 | -3377.57
20270.60122.102 | -1.47
20350.60121.102 | -1828.94
20510.60122.102 | -360.74
20540.60121.102 | 0.46
20540.60122.102 | 0.4
20610.60121.102 | -6332
20610.60122.102 | -975.63
20615.60121.102 | -20123.76
20615.60122.102 | -3.8
20620.60121.102 | 0.83
20620.60122.102 | 0.16
20625.60121.102 | 0.05
20625.60122.102 | -33.9
20630.60121.102 | 0.33
20630.60122.102 | -1.98
20635.60121.102 | 0.06
20635.60122.102 | 5.68
20640.60121.102 | 65.4
20640.60122.102 | 40.13
20645.60121.102 | 0.04
20645.60122.102 | -16.02
20650.60121.102 | -0.14
20650.60122.102 | -1
20825.60121.102 | 0.3
20910.60121.102 | -0.06
20915.60121.102 | -0.04
20915.60122.102 | -1.94
20940.60122.102 | -198.7
20950.60122.102 | -8.55
20960.60121.102 | -1.8
20965.60121.102 | -22.14
20965.60122.102 | -19.25
25141.60122.102 | 496.11
25150.60121.102 | -984.04
25151.60122.102 | 9.78
25157.60121.102 | 1.4
25160.60122.102 | 101.58
28046.60121.102 | -1.72
28047.60121.102 | -2.92
28049.60121.102 | 1.05
28050.60121.102 | -0.26
28093.60121.102 | 55.38
28094.60121.102 | 1.4
28103.60121.102 | 1.22
20215.60210.102 | -683.23
20265.60210.102 | 36.23
20510.60210.102 | 209.63
20820.60210.102 | 444.57