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

GL Balances |  | GL to Count
20240.15100.002 | 0 |  |  |  |  | ** If you have a variance in H4 on the GL to Count tab, copy and paste GL balances into columns A & B, Filter in N/A in column C and any balances in column B; Add these GL account to GL to Count tab **
20240.15100.003 | 0
20240.15100.004 | 0
20245.15100.001 | 1094.29
20245.15100.002 | 0
20245.15100.003 | 0
20245.15100.004 | 0
20250.15100.001 | 14325
20250.15100.002 | 0
20250.15100.003 | 7360.11
20250.15100.004 | 0
20255.15100.001 | 0
20255.15100.002 | 0
20255.15100.003 | 0
20255.15100.004 | 0
20260.15100.001 | 0
20260.15100.002 | 0
20260.15100.003 | 0
20260.15100.004 | 0
20265.15100.001 | 9.09494701772928e-13
20265.15100.002 | 0
20265.15100.003 | 0
20265.15100.004 | 0
20270.15100.001 | 0
20270.15100.002 | 0
20270.15100.003 | 0
20270.15100.004 | 0
20310.15100.001 | 0
20310.15100.002 | 0
20310.15100.003 | 0
20310.15100.004 | 0
20320.15100.001 | 4080.62
20320.15100.002 | 0
20320.15100.003 | 0
20320.15100.004 | 0
20330.15100.001 | 6502.87
20330.15100.002 | 0
20330.15100.003 | 0
20330.15100.004 | 0
20340.15100.001 | 0
20340.15100.002 | 0
20340.15100.003 | 0
20340.15100.004 | 0
20350.15100.001 | 1.02313990613112e-14
20350.15100.002 | 0
20350.15100.003 | 0
20350.15100.004 | 0
20360.15100.001 | 10184.76
20360.15100.002 | 0
20360.15100.003 | 0
20360.15100.004 | 0
20365.15100.001 | 2854.31
20365.15100.002 | 0
20365.15100.003 | 0
20365.15100.004 | 0
20410.15100.001 | 0
20410.15100.002 | 0
20410.15100.003 | 0
20410.15100.004 | 0
20510.15100.001 | 1520.91
20510.15100.002 | 0
20510.15100.003 | 0
20510.15100.004 | 0
20520.15100.001 | 0
20520.15100.002 | 0
20520.15100.003 | 0
20520.15100.004 | 0
20530.15100.001 | 0
20530.15100.002 | 0
20530.15100.003 | 0
20530.15100.004 | 0
20810.15100.001 | 5.45696821063757e-12
20810.15100.002 | 0
20810.15100.003 | -1.49213974509621e-13
20810.15100.004 | 0
20815.15100.001 | 604.17
20815.15100.002 | 0
20815.15100.003 | 0
20815.15100.004 | 0
20820.15100.001 | 31378.43
20820.15100.002 | 0
20820.15100.003 | 0
20820.15100.004 | 0
20825.15100.001 | 0
20825.15100.002 | 0
20825.15100.003 | 0
20825.15100.004 | 0
20710.15100.001 | 0
20710.15100.002 | 0
20710.15100.003 | 0
20710.15100.004 | 0
20960.15100.001 | 0
20960.15100.002 | 0
20960.15100.003 | 0
20960.15100.004 | 0
20720.15100.001 | 0
20720.15100.002 | 0
20720.15100.003 | 0
20720.15100.004 | 0
20965.15100.001 | 0
20965.15100.002 | 0
20965.15100.003 | 0
20965.15100.004 | 0
20940.15100.001 | -1.81898940354586e-12
20940.15100.002 | 0
20940.15100.003 | 0
20940.15100.004 | 0
20910.15100.001 | 0
20910.15100.002 | 0
20910.15100.003 | 0
20910.15100.004 | 0
20930.15100.001 | 0
20930.15100.002 | 0
20930.15100.003 | 0
20930.15100.004 | 0
20531.15100.001 | 0
20531.15100.002 | 0
20531.15100.003 | 0
20531.15100.004 | 0
20275.15100.001 | 0
20285.15100.001 | -100.98
20290.15100.001 | 0
20295.15100.001 | 0
20540.15100.001 | 0
20550.15100.001 | 0
20560.15100.001 | 0
20580.15100.001 | -1966.3
20610.15100.001 | 0
20615.15100.001 | 1781.12
20620.15100.001 | 32641.92
20625.15100.001 | 5987.53
20630.15100.001 | 0
20635.15100.001 | 5.10000000000116
20640.15100.001 | 0
20645.15100.001 | 0
20650.15100.001 | 0
20915.15100.001 | 0
20950.15100.001 | 0
25106.15100.001 | 0
25111.15100.001 | 0
25116.15100.001 | -3.23999999999069
25121.15100.001 | 0
25126.15100.001 | 0
25131.15100.001 | 0
25136.15100.001 | 0
25141.15100.001 | 0
25146.15100.001 | 0
25150.15100.001 | -9655.95999999996
25151.15100.001 | 22658.42
25157.15100.001 | 122894.82
25160.15100.001 | 0
25206.15100.001 | 0
25211.15100.001 | 0
25216.15100.001 | 0
25220.15100.001 | 0.33
25230.15100.001 | 0
25236.15100.001 | 0
25240.15100.001 | 0
25245.15100.001 | 0
25320.15100.001 | 0
25330.15100.001 | 0
25335.15100.001 | 0
25340.15100.001 | 0
25405.15100.001 | 0
25406.15100.001 | 0
25410.15100.001 | 0
25415.15100.001 | 0
26105.15100.001 | 0
26110.15100.001 | 8382.6
26120.15100.001 | 0
26125.15100.001 | 0
26205.15100.001 | 0
26210.15100.001 | 3.06954461848363e-12
26213.15100.001 | 0
26215.15100.001 | 0
26220.15100.001 | 0
26225.15100.001 | 0
26230.15100.001 | 0
26235.15100.001 | 0
26240.15100.001 | 0
26245.15100.001 | 5225.92
26250.15100.001 | 0
26255.15100.001 | 0
26260.15100.001 | 0
26265.15100.001 | 0
26276.15100.001 | 0
20275.15100.002 | 0
20285.15100.002 | 0
20290.15100.002 | 0
20295.15100.002 | 0
20540.15100.002 | 0
20550.15100.002 | 0
20560.15100.002 | 0
20580.15100.002 | 0
20610.15100.002 | 0
20615.15100.002 | 0
20620.15100.002 | 0
20625.15100.002 | 0
20630.15100.002 | 0
20635.15100.002 | 0
20640.15100.002 | 0
20645.15100.002 | 0
20650.15100.002 | 0
20915.15100.002 | 0
20950.15100.002 | 0
25106.15100.002 | 0
25111.15100.002 | 0
25116.15100.002 | 0
25121.15100.002 | 0
25126.15100.002 | 0
25131.15100.002 | 0
25136.15100.002 | 0
25141.15100.002 | 0
25146.15100.002 | 0
25150.15100.002 | 0
25151.15100.002 | 0
25157.15100.002 | 0
25160.15100.002 | 0
25206.15100.002 | 0
25211.15100.002 | 0
25216.15100.002 | 0
25220.15100.002 | 0
25230.15100.002 | 0
25236.15100.002 | 0
25240.15100.002 | 0
25245.15100.002 | 0
25320.15100.002 | 0
25330.15100.002 | 0
25335.15100.002 | 0
25340.15100.002 | 0
25405.15100.002 | 0
25406.15100.002 | 0
25410.15100.002 | 0
25415.15100.002 | 0
26105.15100.002 | 0
26110.15100.002 | 0
26120.15100.002 | 0
26125.15100.002 | 0
26205.15100.002 | 0
26210.15100.002 | 0
26213.15100.002 | 0
26215.15100.002 | 0
26220.15100.002 | 0
26225.15100.002 | 0
26230.15100.002 | 0
26235.15100.002 | 0
26240.15100.002 | 0
26245.15100.002 | 0
26250.15100.002 | 0
26255.15100.002 | 0
26260.15100.002 | 0
26265.15100.002 | 0
26276.15100.002 | 0
20275.15100.003 | 0
20285.15100.003 | 0
20290.15100.003 | 0
20295.15100.003 | 0
20540.15100.003 | 0
20550.15100.003 | 0
20560.15100.003 | 0
20580.15100.003 | 0
20610.15100.003 | 0
20615.15100.003 | 0
20620.15100.003 | 0
20625.15100.003 | 0
20630.15100.003 | 0
20635.15100.003 | 0
20640.15100.003 | 0
20645.15100.003 | 0
20650.15100.003 | 0
20915.15100.003 | 0
20950.15100.003 | 0
25106.15100.003 | 0
25111.15100.003 | 0
25116.15100.003 | 0
25121.15100.003 | 0
25126.15100.003 | 0
25131.15100.003 | 0
25136.15100.003 | 0
25141.15100.003 | 0
25146.15100.003 | 0
25150.15100.003 | 0
25151.15100.003 | 0
25157.15100.003 | 0
25160.15100.003 | 0
25206.15100.003 | 0
25211.15100.003 | 0
25216.15100.003 | 0
25220.15100.003 | 0
25230.15100.003 | 0
25236.15100.003 | 0
25240.15100.003 | 0
25245.15100.003 | 0
25320.15100.003 | 0
25330.15100.003 | 0
25335.15100.003 | 0
25340.15100.003 | 0
25405.15100.003 | 0
25406.15100.003 | 0
25410.15100.003 | 0
25415.15100.003 | 0
26105.15100.003 | 0
26110.15100.003 | 0
26120.15100.003 | 0
26125.15100.003 | 0
26205.15100.003 | 0
26210.15100.003 | 0
26213.15100.003 | 0
26215.15100.003 | 0
26220.15100.003 | 0
26225.15100.003 | 0
26230.15100.003 | 0
26235.15100.003 | 0
26240.15100.003 | 0
26245.15100.003 | 0
26250.15100.003 | 0
26255.15100.003 | 0
26260.15100.003 | 0
26265.15100.003 | 0
26276.15100.003 | 0
20275.15100.004 | 0
20285.15100.004 | 0
20290.15100.004 | 0
20295.15100.004 | 0
20540.15100.004 | 0
20550.15100.004 | 0
20560.15100.004 | 0
20580.15100.004 | 0
20610.15100.004 | 0
20615.15100.004 | 0
20620.15100.004 | 0
20625.15100.004 | 0
20630.15100.004 | 0
20635.15100.004 | 0
20640.15100.004 | 0
20645.15100.004 | 0
20650.15100.004 | 0
20915.15100.004 | 0
20950.15100.004 | 0
25106.15100.004 | 0
25111.15100.004 | 0
25116.15100.004 | 0
25121.15100.004 | 0
25126.15100.004 | 0
25131.15100.004 | 0
25136.15100.004 | 0
25141.15100.004 | 0
25146.15100.004 | 0
25150.15100.004 | 0
25151.15100.004 | 0
25157.15100.004 | 0
25160.15100.004 | 0
25206.15100.004 | 0
25211.15100.004 | 0
25216.15100.004 | 0
25220.15100.004 | 0
25230.15100.004 | 0
25236.15100.004 | 0
25240.15100.004 | 0
25245.15100.004 | 0
25320.15100.004 | 0
25330.15100.004 | 0
25335.15100.004 | 0
25340.15100.004 | 0
25405.15100.004 | 0
25406.15100.004 | 0
25410.15100.004 | 0
25415.15100.004 | 0
26105.15100.004 | 0
26110.15100.004 | 0
26120.15100.004 | 0
26125.15100.004 | 0
26205.15100.004 | 0
26210.15100.004 | 0
26213.15100.004 | 0
26215.15100.004 | 0
26220.15100.004 | 0
26225.15100.004 | 0
26230.15100.004 | 0
26235.15100.004 | 0
26240.15100.004 | 0
26245.15100.004 | 0
26250.15100.004 | 0
26255.15100.004 | 0
26260.15100.004 | 0
26265.15100.004 | 0
26276.15100.004 | 0
25110.15100.001 | 0.00999999999930878
25115.15100.001 | 7.62999999997555
25120.15100.001 | 1.06999999999971
25130.15100.001 | 0.659999999999854
20210.15150.001 | 4834.26
20215.15150.001 | 13047.76
20220.15150.001 | 121761.72
20225.15150.001 | 83238.46
20230.15150.001 | 61011.93
20240.15150.001 | 79499.4
20245.15150.001 | 212620.49
20250.15150.001 | 186348.02
20255.15150.001 | 0
20260.15150.001 | 162540.38
20265.15150.001 | 25659.24
20270.15150.001 | 91370.72
20275.15150.001 | -3859.6
20285.15150.001 | -17085.78
20290.15150.001 | 0
20295.15150.001 | 0
20310.15150.001 | 10049.97
20320.15150.001 | 27038.01
20330.15150.001 | 15459.12
20340.15150.001 | 0
20350.15150.001 | -5.6621374255883e-15
20360.15150.001 | 14893.67
20365.15150.001 | 8456.86
20410.15150.001 | 0
20510.15150.001 | 73687.93
20520.15150.001 | 0
20530.15150.001 | 0
20531.15150.001 | 0
20540.15150.001 | -6404.79
20550.15150.001 | 0
20560.15150.001 | 11989.44
20580.15150.001 | -7.77000000000044
20610.15150.001 | 430.77
20615.15150.001 | -25194.2
20620.15150.001 | 16867.01
20625.15150.001 | 9481.02
20630.15150.001 | 14226.48
20635.15150.001 | 21852.25
20640.15150.001 | 11462.21
20645.15150.001 | 3985.89
20650.15150.001 | 6538.07
20710.15150.001 | 0
20720.15150.001 | 0
20810.15150.001 | 9259.92999999998
20815.15150.001 | 5045.55000000001
20820.15150.001 | 98127.68
20825.15150.001 | 15508.41
20910.15150.001 | 0
20915.15150.001 | 0
20930.15150.001 | 0
20940.15150.001 | 0
20950.15150.001 | 0
20960.15150.001 | 0
20965.15150.001 | 0
25106.15150.001 | 0
25110.15150.001 | 8411.18
25111.15150.001 | -9.09494701772928e-13
25115.15150.001 | 1930.79000000001
25116.15150.001 | -2046.58
25120.15150.001 | -1.08999999999651
25121.15150.001 | 0
25126.15150.001 | 2.18278520258686e-13
25130.15150.001 | -22.2699999999968
25131.15150.001 | -5.29000000000175
25136.15150.001 | 456.640000000005
25141.15150.001 | 1731.12000000001
25146.15150.001 | 0
25150.15150.001 | 65146.78
25151.15150.001 | 12497.95
25157.15150.001 | 217608.29
25160.15150.001 | 38240.14
25206.15150.001 | 0
25211.15150.001 | 0
25216.15150.001 | 0
25220.15150.001 | 0.26
25230.15150.001 | 0
25236.15150.001 | 0
25240.15150.001 | 0
25245.15150.001 | 0
25320.15150.001 | 3420.5
25330.15150.001 | -26466.68
25335.15150.001 | 37600.71
25340.15150.001 | 0
25405.15150.001 | 0
25406.15150.001 | -0.649999999999545
25410.15150.001 | 0
25415.15150.001 | 0
26105.15150.001 | 1.60071955690455e-12
26110.15150.001 | 17924.51
26120.15150.001 | 69766.82
26125.15150.001 | 7593.58999999999
26205.15150.001 | 63279.83
26210.15150.001 | 7.04858393874019e-12
26213.15150.001 | 16708.03
26215.15150.001 | 67412.06
26220.15150.001 | 43075.73
26225.15150.001 | 39870.23
26230.15150.001 | 22180.85
26235.15150.001 | 20021.3
26240.15150.001 | 3.63797880709171e-12
26245.15150.001 | 62481.68
26250.15150.001 | 0
26255.15150.001 | 54596.2
26260.15150.001 | 6469.47
26265.15150.001 | 45705.94
26276.15150.001 | 0
20210.15150.002 | 8941.51999999999
20215.15150.002 | 1650.94
20220.15150.002 | 46606.59
20225.15150.002 | 27583.73
20230.15150.002 | 103764.71
20240.15150.002 | 108326.31
20245.15150.002 | 125585.45
20250.15150.002 | 135691.5
20255.15150.002 | 0
20260.15150.002 | 140279.14
20265.15150.002 | 44696.98
20270.15150.002 | 42110.68
20275.15150.002 | -155.420000000002
20285.15150.002 | -5921.41
20290.15150.002 | 0
20295.15150.002 | -558.97
20310.15150.002 | 0
20320.15150.002 | 0
20330.15150.002 | 0
20340.15150.002 | 0
20350.15150.002 | 0
20360.15150.002 | 0
20365.15150.002 | 0
20410.15150.002 | 0
20510.15150.002 | -42500.05
20520.15150.002 | 0
20530.15150.002 | 0
20531.15150.002 | 0
20540.15150.002 | 6580.97
20550.15150.002 | 0
20560.15150.002 | -241.189999999999
20580.15150.002 | 0
20610.15150.002 | -63273.61
20615.15150.002 | 13218.41
20620.15150.002 | 4476.34
20625.15150.002 | -0.429999999999609
20630.15150.002 | 2315.8
20635.15150.002 | 14873.37
20640.15150.002 | -16830.12
20645.15150.002 | 7135.21
20650.15150.002 | 13772.37
20710.15150.002 | 0
20720.15150.002 | 0
20810.15150.002 | 52797.98
20815.15150.002 | 0
20820.15150.002 | 102027.06
20825.15150.002 | 0
20910.15150.002 | 0
20915.15150.002 | 0
20930.15150.002 | 0
20940.15150.002 | 0
20950.15150.002 | 0
20960.15150.002 | 0
20965.15150.002 | 0
25106.15150.002 | -6.82093270754081e-14
25110.15150.002 | 12682.47
25111.15150.002 | 0
25115.15150.002 | 0.190000000002328
25116.15150.002 | 116.87
25120.15150.002 | -0.380000000004657
25121.15150.002 | 0
25126.15150.002 | 362.399999999999
25130.15150.002 | -932.940000000002
25131.15150.002 | 1.33999999999245
25136.15150.002 | -0.00999999999997272
25141.15150.002 | -0.0200000000003638
25146.15150.002 | 0
25150.15150.002 | 0
25151.15150.002 | 21766.72
25157.15150.002 | 229.24
25160.15150.002 | 50186.29
25206.15150.002 | 0
25211.15150.002 | 0
25216.15150.002 | 0
25220.15150.002 | 0.15
25230.15150.002 | 0
25236.15150.002 | 0
25240.15150.002 | 0
25245.15150.002 | 0
25320.15150.002 | 37381.82
25330.15150.002 | 10603.33
25335.15150.002 | 35788.39
25340.15150.002 | 0
25405.15150.002 | 0
25406.15150.002 | -130.13
25410.15150.002 | 0
25415.15150.002 | 0
26105.15150.002 | 0
26110.15150.002 | 0
26120.15150.002 | 0
26125.15150.002 | 0
26205.15150.002 | 0
26210.15150.002 | 0
26213.15150.002 | 0
26215.15150.002 | 0
26220.15150.002 | 0
26225.15150.002 | 0
26230.15150.002 | 0
26235.15150.002 | 0
26240.15150.002 | 0
26245.15150.002 | 0
26250.15150.002 | 0
26255.15150.002 | 0
26260.15150.002 | 0
26265.15150.002 | 0
26276.15150.002 | 0
20210.15410 | 0
20215.15410 | 7429.43
20220.15410 | 0
20225.15410 | 0
20230.15410 | 0
20240.15410 | 0
20245.15410 | 0
20250.15410 | 0
20255.15410 | 0
20260.15410 | 0
20265.15410 | 42660.1
20270.15410 | 0
20275.15410 | 0
20285.15410 | 0
20290.15410 | 0
20295.15410 | 0
20310.15410 | 0
20320.15410 | 0
20330.15410 | 0
20340.15410 | 0
20350.15410 | 0
20360.15410 | 0
20365.15410 | 0
20410.15410 | 97191.86
20510.15410 | 923.93
20520.15410 | 0
20530.15410 | 0
20531.15410 | 0
20540.15410 | 0
20550.15410 | 0
20560.15410 | 0
20580.15410 | 0
20610.15410 | 0
20615.15410 | 0
20620.15410 | 0
20625.15410 | 0
20630.15410 | 0
20635.15410 | 0
20640.15410 | 0
20645.15410 | 0
20650.15410 | 0
20710.15410 | 0
20720.15410 | 0
20810.15410 | 0
20815.15410 | 0
20820.15410 | 22938.28
20825.15410 | 0
20910.15410 | 0
20915.15410 | 0
20930.15410 | 0
20940.15410 | 0
20950.15410 | 0
20960.15410 | 0
20965.15410 | 0
25106.15410 | 0
25110.15410 | 0
25111.15410 | 0
25115.15410 | 0
25116.15410 | 0
25120.15410 | 0
25121.15410 | 0
25126.15410 | 0
25130.15410 | 0
25131.15410 | 0
25136.15410 | 0
25141.15410 | 0
25146.15410 | 0
25150.15410 | 0
25151.15410 | 0
25157.15410 | 0
25160.15410 | 0
25206.15410 | 0
25211.15410 | 0
25216.15410 | 0
25220.15410 | 0
25230.15410 | 0
25236.15410 | 0
25240.15410 | 0
25245.15410 | 0
25320.15410 | 0
25330.15410 | 0
25335.15410 | 0
25340.15410 | 0
25405.15410 | 0
25406.15410 | 0
25410.15410 | 0
25415.15410 | 0
26105.15410 | 0
26110.15410 | 0
26120.15410 | 0
26125.15410 | 0
26205.15410 | 0
26210.15410 | 0
26213.15410 | 0
26215.15410 | 0
26220.15410 | 0
26225.15410 | 0
26230.15410 | 0
26235.15410 | 0
26240.15410 | 0
26245.15410 | 0
26250.15410 | 0
26255.15410 | 0
26260.15410 | 0
26265.15410 | 0
26276.15410 | 0
20210.15150.004 | 0
20215.15150.004 | 0
20220.15150.004 | 0
20225.15150.004 | 0
20230.15150.004 | 0
20240.15150.004 | 0
20245.15150.004 | 0
20250.15150.004 | 0
20255.15150.004 | 0
20260.15150.004 | 0
20265.15150.004 | 0
20270.15150.004 | 0
20410.15150.004 | 0
20510.15150.004 | -12934.56
20520.15150.004 | 0
20530.15150.004 | 0
20810.15150.004 | 0
20820.15150.004 | 0
20825.15150.004 | 0
20710.15150.004 | 0
20960.15150.004 | 0
20720.15150.004 | 0
20965.15150.004 | 0
20940.15150.004 | 0
20910.15150.004 | 0
20930.15150.004 | 0
20915.15150.004 | 0