Spreadsheet: 89656d1289415703-sumif-not-working-the-way-i-want-2011-budget-wip-trimmed
Sheet: entity

ENTITY | [NAME] |  | NT- | NO | NT-
001 | [NAME] | RANGES: | 000 | TO | 000
001 |  |  | 085 | TO | 085
002 | COMANCHE | RANGES: | 002 | TO | 002
002 |  |  | 200 | TO | 299
002 |  |  | 2AA | TO | 2zz
003 | DUBLIN | RANGES: | 003 | TO | 003
003 |  |  | 300 | TO | 399
003 |  |  | 3AA | TO | 3zz
004 | STEPHENVILLE | RANGES: | 004 | TO | 004
004 |  |  | 400 | TO | 499
004 |  |  | 4AA | TO | 4zz
005 | ABERNATHY | RANGES: | 001 | TO | 001
005 |  |  | 005 | TO | 005
005 |  |  | 100 | TO | 199
005 |  |  | 1AA | TO | 1zz
005 |  |  | 500 | TO | 599
005 |  |  | 5AA | TO | 5zz
006 | BROWNFIELD | RANGES: | 006 | TO | 006
006 |  |  | 064 | TO | 064
006 |  |  | 600 | TO | 699
006 |  |  | 6AA | TO | 6zz
006 |  |  | n00 | TO | n99
006 |  |  | nAA | TO | nzz
007 | DENVER CITY | RANGES: | 007 | TO | 007
007 |  |  | 700 | TO | 799
007 |  |  | 7AA | TO | 7zz
008 | CROSS PLAINS | RANGES: | 008 | TO | 008
008 |  |  | 800 | TO | 899
008 |  |  | 8AA | TO | 8zz
009 | BALLINGER | RANGES: | 009 | TO | 009
009 |  |  | 900 | TO | 999
009 |  |  | 9AA | TO | 9zz
011 | WINTERS | RANGES: | 011 | TO | 011
011 |  |  | [NAME] | TO | A99
011 |  |  | AAA | TO | Azz
013 | BRADY | RANGES: | 013 | TO | 013
013 |  |  | B00 | TO | B99
013 |  |  | [NAME] | TO | Bzz
014 | HAMILTON | RANGES: | 014 | TO | 014
014 |  |  | D00 | TO | D99
014 |  |  | DAA | TO | [NAME]
017 | LITTLEFIELD | RANGES: | 017 | TO | 017
017 |  |  | E00 | TO | E99
017 |  |  | EAA | TO | Ezz
018 | MATADOR | RANGES: | 018 | TO | 018
019 | [NAME] | RANGES: | 019 | TO | 019
019 |  |  | F00 | TO | Fzz
020 | COLORADO CITY | RANGES: | 020 | TO | 020
020 |  |  | 062 | TO | 062
020 |  |  | 600 | TO | 699
020 |  |  | l00 | TO | lzz
020 |  |  | 6AA | TO | 6zz
021 | GATESVILLE | RANGES: | 021 | TO | 021
021 |  |  | H00 | TO | Hzz
022 | PINELAND | RANGES: | 022 | TO | 022
022 |  |  | I00 | TO | Izz
023 | LUFKIN | RANGES: | 023 | TO | 023
023 |  |  | J00 | TO | Jzz
024 | CONROE | RANGES: | 024 | TO | 024
024 |  |  | K00 | TO | [NAME]
026 | DIBOLL | RANGES: | 026 | TO | 026
027 | BIG SPRING | RANGES: | 027 | TO | 027
027 |  |  | M00 | TO | [NAME]
029 | PETERSBURG | RANGES: | 029 | TO | 029
031 | POST | RANGES: | 031 | TO | 031
031 |  |  | O00 | TO | Ozz
032 | [NAME] | RANGES: | 032 | TO | 032
032 |  |  | P00 | TO | Pzz
033 | FLOYDADA | RANGES: | 033 | TO | 033
034 | HEREFORD | RANGES: | 034 | TO | 034
034 |  |  | Q00 | TO | [NAME]
035 | IDALOU | RANGES: | 035 | TO | 035
036 | ROTAN | RANGES: | 036 | TO | 036
037 | STAMFORD | RANGES: | 037 | TO | 037
037 |  |  | T00 | TO | [NAME]
038 | [NAME] | RANGES: | 038 | TO | 038
038 |  |  | U00 | TO | Uzz
039 | SNYDER | RANGES: | 039 | TO | 039
039 |  |  | V00 | TO | Vzz
040 | STANTON | RANGES: | 040 | TO | 040
041 | MORTON | RANGES: | 041 | TO | 041
042 | SWEETWATER | RANGES: | 042 | TO | 042
042 |  |  | Y00 | TO | Yzz
043 | TAHOKA | RANGES: | 043 | TO | 043
043 |  |  | Z00 | TO | Zzz
044 | WOLFE CITY | RANGES: | 044 | TO | 044
044 |  |  | a00 | TO | azz
045 | FORT DAVIS | RANGES: | 045 | TO | 045
045 |  |  | b00 | TO | bzz
047 | EARTH | RANGES: | 047 | TO | 047
048 | MERKEL | RANGES: | 048 | TO | 048
049 | DIMMITT | RANGES: | 049 | TO | 049
049 |  |  | e00 | TO | ezz
050 | Pass Through | RANGES: | 050 | TO | 050
050 |  |  | f00 | TO | fzz
051 | PASS THRU | RANGES: | 051 | TO | 051
051 |  |  | 050 | TO | 050
053 | [NAME] | RANGES: | 053 | TO | 053
053 |  |  | g00 | TO | gzz
054 | ALBANY | RANGES: | 054 | TO | 054
054 |  |  | h00 | TO | hzz
056 | BRECKENRIDGE | RANGES: | 056 | TO | 056
056 |  |  | 063 | TO | 063
056 |  |  | i00 | TO | izz
056 |  |  | [NAME] | TO | mzz
057 | LAMESA | RANGES: | 057 | TO | 057
057 |  |  | j00 | TO | jzz
058 | CROSBYTON | RANGES: | 058 | TO | 058
059 | LEVELLAND | RANGES: | 059 | TO | 059
059 |  |  | k00 | TO | kzz
061 | GENERAL OFFICE OTHER | RANGES: | 061 | TO | 061
062 | COLORADO CITY | RANGES: | 020 | TO | 020
062 |  |  | 062 | TO | 062
062 |  |  | 600 | TO | 699
062 |  |  | l00 | TO | lzz
062 |  |  | 6AA | TO | 6zz
063 | BRECKENRIDGE | RANGES: | 056 | TO | 056
063 |  |  | 063 | TO | 063
063 |  |  | i00 | TO | izz
063 |  |  | [NAME] | TO | mzz
064 | BROWNFIELD | RANGES: | 006 | TO | 006
064 |  |  | 064 | TO | 064
064 |  |  | 600 | TO | 699
064 |  |  | 6AA | TO | 6zz
064 |  |  | n00 | TO | nzz
065 | MIDLOTHIAN | RANGES: | 065 | TO | 065
065 |  |  | o00 | TO | ozz
066 | COLEMAN | RANGES: | 066 | TO | 066
066 |  |  | p00 | TO | pzz
070 | MOODY | RANGES: | 070 | TO | 070
071 | BROWNWOOD | RANGES: | 071 | TO | 071
071 |  |  | 012 | TO | 012
071 |  |  | s00 | TO | szz
072 | MENARD | RANGES: | 072 | TO | 072
072 |  |  | v00 | TO | vzz
073 | MULESHOE | RANGES: | 073 | TO | 073
073 |  |  | 046 | TO | 046
073 |  |  | w00 | TO | [NAME]
074 | TYLER | RANGES: | 074 | TO | 074
074 |  |  | x00 | TO | xzz
076 | ABILENE HBC PAINT | RANGES: | 076 | TO | 076
076 |  |  | y00 | TO | yzz
077 | ABILENE | RANGES: | 077 | TO | 077
077 |  |  | z00 | TO | zzz
086 | HIGG-HILL GENERAL OFFICE | RANGES: | 086 | TO | 086
087 | HBC EQUIPMENT LEASING CO., LTD | RANGES: | 087 | TO | 087
088 | ELIMINATING COMPANY | RANGES: | 088 | TO | 088
089 | HBC LEASING CO., LTD | RANGES: | 089 | TO | 089