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

20 | LF
30 | LEG
40 | LIT | REVENUES:
60 | SR
70 | RNG | 4057-LLL | TO | 4057-LLL
80 | RNG | 4098-LLL | TO | 4098-LLL
90 | RNG | 4020-LLL | TO | 4020-LLL
100 | RNG | 4026-LLL | TO | 4026-LLL
101 | RNG | 4058-LLL | TO | 4058-LLL
110 | RNG | 4068-LLL | TO | 4068-LLL
120 | RNG | 4090-LLL | TO | 4090-LLL
130 | RNG | 4095-LLL | TO | 4095-LLL
140 | RNG | 4050-LLL | TO | 4050-LLL
150 | RNG | 4065-LLL | TO | 4065-LLL
160 | RNG | 4001-LLL | TO | 4001-LLL
170 | RNG | 4073-LLL | TO | 4073-LLL
180 | RNG | 4070-LLL | TO | 4070-LLL
190 | RNG | 4076-LLL | TO | 4076-LLL
200 | RNG | 4067-LLL | TO | 4067-LLL
210 | RNG | 4081-LLL | TO | 4081-LLL
220 | RNG | 4071-LLL | TO | 4071-LLL
230 | RNG | 4000-LLL | TO | 4000-LLL
240 | RNG | 4100-LLL | TO | 4100-LLL
260 | RNG | 4200-LLL | TO | 4200-LLL
270 | RNG | 4105-LLL | TO | 4105-LLL
280 | RNG | 4072-LLL | TO | 4072-LLL
290 | RNG | 4097-LLL | TO | 4097-LLL
300 | RNG | 4060-LLL | TO | 4060-LLL
310 | RNG | 4074-LLL | TO | 4074-LLL
320 | RNG | 4085-LLL | TO | 4085-LLL
330 | RNG | 4010-LLL | TO | 4010-LLL
340 | RNG | 4016-LLL | TO | 4016-LLL
350 | RNG | 4009-LLL | TO | 4009-LLL
360 | RNG | 4075-LLL | TO | 4075-LLL
370 | RNG | 4092-LLL | TO | 4092-LLL
380 | RNG | 4082-LLL | TO | 4082-LLL
390 | RNG | 4077-LLL | TO | 4077-LLL
400 | RNG | 4078-LLL | TO | 4078-LLL
410 | RNG | 4040-LLL | TO | 4040-LLL
420 | RNG | 4066-LLL | TO | 4066-LLL
430 | RNG | 4606-LLL | TO | 4608-LLL
440 | RNG | 4665-LLL | TO | 4665-LLL
460 | RNG | 4080-LLL | TO | 4080-LLL
470 |  | 4099-LLL |  | 4099-LLL
480 |  | 4030-LLL |  | 4030-LLL
490 |  | 4069-LLL |  | 4069-LLL
500 |  | 4110-LLL |  | 4110-LLL
510
520 | LIT | LESS:
530 | RNG | 6135-LLL | TO | 6135-LLL
540 | RNG | 4800-LLL | TO | 4800-LLL
550 | RNG | 4900-LLL | TO | 4900-LLL
560 | UL
580 | SUB1 | TOTAL REVENUE
590 | LF
600 | LIT | 5057-LLL | TO | 5057-LLL
610 | SR | 5098-LLL | TO | 5098-LLL
620 | RNG | 5020-LLL | TO | 5020-LLL
621 | RNG | 5026-LLL | TO | 5026-LLL
630 | RNG | 5058-LLL | TO | 5058-LLL
640 | RNG | 5068-LLL | TO | 5068-LLL
650 | RNG | 5090-LLL | TO | 5090-LLL
660 | RNG | 5095-LLL | TO | 5095-LLL
670 | RNG | 5300-LLL | TO | 5300-LLL
680 | RNG | 5050-LLL | TO | 5050-LLL
690 | RNG | 5065-LLL | TO | 5065-LLL
700 | RNG | 5073-LLL | TO | 5073-LLL
710 | RNG | 5070-LLL | TO | 5070-LLL
720 | RNG | 5076-LLL | TO | 5076-LLL
730 | RNG | 5067-LLL | TO | 5067-LLL
740 | RNG | 5081-LLL | TO | 5081-LLL
760 | RNG | 5071-LLL | TO | 5071-LLL
770 | RNG | 5100-LLL | TO | 5100-LLL
790 | RNG | 5000-LLL | TO | 5000-LLL
800 | RNG | 5200-LLL | TO | 5200-LLL
810 | RNG | 5105-LLL | TO | 5105-LLL
820 | RNG | 5072-LLL | TO | 5072-LLL
830 | RNG | 5097-LLL | TO | 5097-LLL
840 | RNG | 5060-LLL | TO | 5060-LLL
850 | RNG | 5074-LLL | TO | 5074-LLL
860 | RNG | 5085-LLL | TO | 5085-LLL
870 | RNG | 5010-LLL | TO | 5010-LLL
880 | RNG | 5016-LLL | TO | 5016-LLL
890 | RNG | 5009-LLL | TO | 5009-LLL
900 | RNG | 5075-LLL | TO | 5075-LLL
910 | RNG | 5092-LLL | TO | 5092-LLL
920 | RNG | 5082-LLL | TO | 5082-LLL
930 | RNG | 5077-LLL | TO | 5077-LLL
940 | RNG | 5078-LLL | TO | 5078-LLL
950 | RNG | 5040-LLL | TO | 5040-LLL
960 | RNG | 5066-LLL | TO | 5066-LLL
970 | RNG | 5080-LLL | TO | 5080-LLL
980 | RNG | 5099-LLL | TO | 5099-LLL
990 | RNG | 5030-LLL | TO | 5030-LLL
991 | RNG | 5069-LLL | TO | 5069-LLL
1000 | RNG | 5110-LLL | TO | 5110-LLL
1010 | RNG
1020 | RNG
1030 | ER | LESS:
1040 | LF | 5400-LLL | TO | 5400-LLL
1050 | LIT
1060 | RNG | 4750-LLL | TO | 4752-LLL
1070 | RNG | 4485-LLL | TO | 4485-LLL
1080 | RNG | 4753-LLL | TO | 4755-LLL
1090 | RNG | 4745-LLL | TO | 4746-LLL
1100 | RNG | Rebate on Merchandise | Purchase
1110 | PAT
1120 | LF | 6053-LLL | TO | 6053-LLL
1130 | LIT | 6305-LLL | TO | 6305-LLL
1140 | RNG | 6054-LLL | TO | 6054-LLL
1150 | RNG | 5500-LLL | TO | 5500-LLL
1160 | RNG
1170 | RNG
1190 | RNG | 2700-LLL | TO | 2700-LLL
1200 | RNG | 6045-LLL | TO | 6045-LLL
1210 | RNG | 6043-LLL | TO | 6043-LLL
1220 | RNG
1230 | RNG | 6044-LLL | TO | 6044-LLL
1240 | RNG | 6600-LLL | TO | 6600-LLL
1250 | RNG | 6605-LLL | TO | 6605-LLL
1260 | RNG | 6610-LLL | TO | 6610-LLL
1261 |  | 6615-LLL |  | 6615-LLL
1270 | RNG
1280 | PAT | 6047-LLL | TO | 6047-LLL
1290 | UL | 5001-LLL | TO | 5001-LLL
1310 | SUB1 | [NAME] Sh | rink
1320 | UL
1330 | SUB2 | COST OF GOODS SOLD
1350 | LF
1360 | LIT | 7000-LLL | TO | 7000-LLL
1370 | RNG | 6015-LLL | TO | 6015-LLL
1380 | RNG | 4620-LLL | TO | 4620-LLL
1390 | RNG | 6064-LLL | TO | 6064-LLL
1400 | RNG | 6019-LLL | TO | 6019-LLL
1420 | RNG | 7010-LLL | TO | 7010-LLL
1430 | RNG | 6016-LLL | TO | 6016-LLL
1440 | RNG | 7020-LLL | TO | 7020-LLL
1460 | RNG | 6017-LLL | TO | 6017-LLL
1470 | RNG | 7030-LLL | TO | 7030-LLL
1490 | RNG | 7040-LLL | TO | 7040-LLL
1500 | RNG | 6110-LLL | TO | 6110-LLL
1510 | RNG | 7050-LLL | TO | 7050-LLL
1530 | RNG
1540 | RNG
1560 |  | 7060-LLL | TO | 7060-LLL
1570 |  | 6060-LLL | TO | 6062-LLL
1580 |  | 7100-LLL | TO | 7120-LLL
1590 | RNG
1600 | RNG | 6500-LLL | TO | 6500-LLL
1610 | RNG | 7070-LLL | TO | 7080-LLL
1630 | RNG | 7900-LLL | TO | 7900-LLL
1640 | RNG | 6038-LLL | TO | 6038-LLL
1650 | RNG | 8260-LLL | TO | 8260-LLL
1670 | RNG | 6041-LLL | TO | 6041-LLL
1680 | RNG | 8270-LLL | TO | 8270-LLL
1700 | RNG | 6018-LLL | TO | 6018-LLL
1720 | RNG | 7090-LLL | TO | 7090-LLL
1730 | RNG | 6033-LLL | TO | 6033-LLL
1740 | RNG | 7130-LLL | TO | 7150-LLL
1750 | RNG | 6066-LLL | TO | 6066-LLL
1760 | RNG | 7160-LLL | TO | 7160-LLL
1770 | RNG | 6000-LLL | TO | 6000-LLL
1780 | RNG | 6999-LLL | TO | 6999-LLL
1790 | RNG | 7200-LLL | TO | 7200-LLL
1800 | RNG | 6095-LLL | TO | 6095-LLL
1810 | RNG | 7240-LLL | TO | 7240-LLL
1820 | RNG | 6130-LLL | TO | 6130-LLL
1840 | RNG | 6042-LLL | TO | 6042-LLL
1850 | RNG | 6101-LLL | TO | 6101-LLL
1870 | RNG | 6094-LLL | TO | 6094-LLL
1880 | RNG | 6096-LLL | TO | 6096-LLL
1900 | RNG | 6104-LLL | TO | 6104-LLL
1910 | RNG | 6505-LLL | TO | 6505-LLL
1930 | RNG | 6100-LLL | TO | 6100-LLL
1940 | RNG | 6120-LLL | TO | 6120-LLL
1960 | RNG | 7210-LLL | TO | 7230-LLL
1970 | RNG | 7250-LLL | TO | 7280-LLL
1980 | RNG | 6005-LLL | TO | 6009-LLL
2000 | RNG | 7300-LLL | TO | 7330-LLL
2010 | RNG | 6185-LLL | TO | 6185-LLL
2020 | RNG | 7340-LLL | TO | 7340-LLL
2040 | RNG | 6150-LLL | TO | 6150-LLL
2050 | RNG | 7400-LLL | TO | 7400-LLL
2060 | RNG | 6052-LLL | TO | 6052-LLL
2080 | RNG | 7410-LLL | TO | 7410-LLL
2090 | RNG | 7420-LLL | TO | 7450-LLL
2100 | RNG | 6050-LLL | TO | 6051-LLL
2120 | RNG | 7500-LLL | TO | 7500-LLL
2130 | RNG | 6025-LLL | TO | 6025-LLL
2140 | RNG | 6056-LLL | TO | 6056-LLL
2160 | RNG | 7510-LLL | TO | 7510-LLL
2170 | RNG | 7520-LLL | TO | 7530-LLL
2180 | RNG | 6020-LLL | TO | 6020-LLL
2200 | RNG | 7600-LLL | TO | 7600-LLL
2210 | RNG | 7610-LLL | TO | 7620-LLL
2220 | RNG | 6065-LLL | TO | 6065-LLL
2240 | RNG | 7700-LLL | TO | 7700-LLL
2250 | RNG | 7710-LLL | TO | 7710-LLL
2270 | RNG | 6125-LLL | TO | 6125-LLL
2280 | RNG | 7720-LLL | TO | 7720-LLL
2300 | RNG | 7730-LLL | TO | 7730-LLL
2310 | RNG | 6021-LLL | TO | 6021-LLL
2330 | RNG | 7750-LLL | TO | 7750-LLL
2340 | RNG | 6022-LLL | TO | 6022-LLL
2360 | RNG | 6116-LLL | TO | 6116-LLL
2370 | RNG | 7760-LLL | TO | 7760-LLL
2390 | RNG | 6063-LLL | TO | 6063-LLL
2400 | RNG | 8100-LLL | TO | 8100-LLL
2420 | RNG | 6035-LLL | TO | 6035-LLL
2430 | RNG | 8210-LLL | TO | 8210-LLL
2450 | RNG | 6055-LLL | TO | 6055-LLL
2460 | RNG | 7800-LLL | TO | 7810-LLL
2480 | RNG | 6105-LLL | TO | 6105-LLL
2490 | RNG | 7820-LLL | TO | 7820-LLL
2500 | RNG | 6067-LLL | TO | 6067-LLL
2510 | RNG | 7830-LLL | TO | 7830-LLL
2530 | RNG | 7840-LLL | TO | 7850-LLL
2540 | RNG | 6031-LLL | TO | 6031-LLL
2550 | RNG | 6075-LLL | TO | 6075-LLL
2570 | RNG | 7860-LLL | TO | 7860-LLL
2580 | RNG | 6170-LLL | TO | 6170-LLL
2590 | RNG | 7870-LLL | TO | 7870-LLL
2610 | RNG | 6030-LLL | TO | 6030-LLL
2620 | RNG | 6091-LLL | TO | 6091-LLL
2630 | RNG | 6057-LLL | TO | 6057-LLL
2650 | RNG | 7880-LLL | TO | 7880-LLL
2660 | RNG | 6103-LLL | TO | 6103-LLL
2670 | RNG | 6102-LLL | TO | 6102-LLL
2680 | RNG | 7890-LLL | TO | 7890-LLL
2700 | RNG | 7910-LLL | TO | 7910-LLL
2710 | RNG | 6080-LLL | TO | 6080-LLL
2730 | RNG | 7920-LLL | TO | 7920-LLL
2740 | RNG | 6085-LLL | TO | 6085-LLL
2760 | RNG | 6090-LLL | TO | 6090-LLL
2770 | RNG | 7930-LLL | TO | 7940-LLL
2790 | RNG | 7980-LLL | TO | 7980-LLL
2800 | RNG | 9200-LLL | TO | 9200-LLL
2810 | RNG | 6450-LLL | TO | 6450-LLL
2820 | RNG | 7990-LLL | TO | 7990-LLL
2840 | RNG | 6059-LLL | TO | 6059-LLL
2850 | RNG | 8110-LLL | TO | 8110-LLL
2860 | RNG | 6036-LLL | TO | 6036-LLL
2870 | RNG | 8200-LLL | TO | 8200-LLL
2880 | RNG | 6037-LLL | TO | 6037-LLL
2890 | RNG | 8220-LLL | TO | 8220-LLL
2900 | RNG | 8230-LLL | TO | 8230-LLL
2920 | RNG | 8240-LLL | TO | 8240-LLL
2930 | RNG | 6039-LLL | TO | 6039-LLL
2940 | RNG | 8250-LLL | TO | 8250-LLL
2950 | RNG | 6040-LLL | TO | 6040-LLL
2960 | RNG | 6087-LLL | TO | 6087-LLL
2970 | RNG | 6445-LLL | TO | 6445-LLL
2980 | RNG | 6455-LLL | TO | 6455-LLL
2990 | RNG | 6070-LLL | TO | 6070-LLL
3000 | RNG | 6086-LLL | TO | 6086-LLL
3010 | RNG | 8300-LLL | TO | 8340-LLL
3020 | RNG
3040 | UL | TOTAL EXPENSES
3060 | SUB1
3061 | LF
3071 | UL | TOTAL OPERATING INCOM | E
3080 | SUB3
3090 | LF | OTHER INCOME & EXPENS | ES:
3110 | LIT
3120 | LF | 4570-LLL | TO | 4570-LLL
3130 | RNG | 4700-LLL | TO | 4715-LLL
3170 | RNG | 4600-LLL | TO | 4600-LLL
3180 | RNG | 4605-LLL | TO | 4605-LLL
3190 | RNG | 4680-LLL | TO | 4680-LLL
3200 | RNG | 4400-LLL | TO | 4400-LLL
3220 | RNG | 4055-LLL | TO | 4056-LLL
3230 | RNG | 5055-LLL | TO | 5056-LLL
3250 | RNG | 7460-LLL | TO | 7460-LLL
3260 | RNG | 6400-LLL | TO | 6400-LLL
3270 | RNG | 6300-LLL | TO | 6300-LLL
3290 | RNG | 4300-LLL | TO | 4300-LLL
3300 | RNG | 6058-LLL | TO | 6058-LLL
3310 | RNG | 8000-LLL | TO | 8000-LLL
3330 | RNG | 6115-LLL | TO | 6115-LLL
3340 | RNG | 8010-LLL | TO | 8010-LLL
3360 | RNG | 6114-LLL | TO | 6114-LLL
3370 | RNG | 8020-LLL | TO | 8020-LLL
3390 | RNG | 8030-LLL | TO | 8030-LLL
3400 | RNG | 6113-LLL | TO | 6113-LLL
3410 | RNG | 8040-LLL | TO | 8040-LLL
3420 | RNG | 8050-LLL | TO | 8050-LLL
3430 | RNG | 6117-LLL | TO | 6117-LLL
3440 | RNG | 4625-LLL | TO | 4625-LLL
3450 | RNG | 6310-LLL | TO | 6314-LLL
3460 | RNG | 8400-LLL | TO | 8440-LLL
3470 | RNG | 6320-LLL | TO | 6320-LLL
3480 | RNG | 8600-LLL | TO | 8600-LLL
3490 | RNG | 4500-LLL | TO | 4500-LLL
3500 | RNG | 4450-LLL | TO | 4450-LLL
3550 | RNG | 4455-LLL | TO | 4455-LLL
3560 | RNG | 4730-LLL | TO | 4730-LLL
3580 | RNG | 4725-LLL | TO | 4725-LLL
3590 | RNG | 4670-LLL | TO | 4670-LLL
 | RNG | 4675-LLL | TO | 4675-LLL
 | RNG | Other operating incom
 | PAT
 | UL | TOTAL OTHER INCOME/EX
 | SUB3
 | LF
 | UL | 4465-LLL | TO | 4466-LLL
 | RNG | 8900-LLL | TO | 8900-LLL
 | RNG | 4610-LLL | TO | 4611-LLL
 | RNG | 4615-LLL | TO | 4615-LLL
 | RNG