Spreadsheet: 157402d1337715914-sumifs-and-or-statement-05222012-sumifs-help-with-and-statement
Sheet: Running data

ACCOUNT | FMS ITEM ADDRESS | TRAN DATE | [NAME] | TRAN CODE | TRANSACTION AMOUNT | Debit | Credit | Running Balance | find acct # in description | calculated acct # | Name | SHARED_LOSS_QTR
18049008 | 86 | 2011-02-25 00:00:00 | smith-6625 80% ACCR INT 9/30/10 CERT SF | 3 | 595.24
27930008 |  | 2010-09-30 00:00:00 | 40006625 smith LOSS 18928 FILMORE | 3 | 1077.94
27930008 |  | 2010-09-30 00:00:00 | 40006625 smith OREO SALE 18928 FILMORE | 3 | 10831.39
27930008 |  | 2010-09-30 00:00:00 | 40006625 smith 18928 FILMORE | 3 | 35282.21
57050708 | 113971149 | 2011-01-13 00:00:00 | LEGAL 40006805 XUEREB SNOW PC 4750 | 3 | 22.05
57050708 | 515971386 | 2011-05-13 00:00:00 | 40006805 XUEREB SNOW PC 5457 | 3 | 49.96
57050708 | 613971312 | 2011-06-13 00:00:00 | 40006805 XUEREB SNOW PC 5615 | 3 | 190
27930008 |  | 2010-11-12 00:00:00 | 40006805 jones 1941 STATE PARK GAIN | 1 | 10039.95
27930008 |  | 2010-11-12 00:00:00 | 40006805 jones 1941 STATE PARK | 3 | 31858.4
57050208 | 1030971585 | 2011-10-28 00:00:00 | 40006860 OAKLAND COUNTY TREASURER EAO0028324 | 3 | 4
18049008 | 405850026 | 2012-04-05 00:00:00 | 40007425 hanson construction 80% DUE FDIC | 1 | 10507.2
18049008 | 405850027 | 2012-04-05 00:00:00 | ADJUST LOSS SHARE hanson CONST 40007425 | 3 | 10507.2
48098008 | 405850024 | 2012-03-30 00:00:00 | WRITE DOWN DISC hanson CONST TO EQUAL BOOK VALUE 40007425 | 1 | 13134
48098008 | 405850025 | 2012-03-30 00:00:00 | 40007425 hanson construction 80% DUE FDIC | 3 | 10507.2
57050708 | 1209971324 | 2010-12-09 00:00:00 | LEGAL 40007425 COUZENS, LANSKY, FEALK, ELLIS 51039 | 3 | 600
57050708 | 1214971125 | 2010-12-14 00:00:00 | TAXES 40007425 CITY OF TROY [PHONE] | 3 | 697.28
57050708 | 1214971126 | 2010-12-14 00:00:00 | TAXES 40007425 CITY OF TROY [PHONE] | 3 | 697.28
57050708 | 1214971127 | 2010-12-14 00:00:00 | TAXES 40007425 SUMMER CITY OF TROY [PHONE] | 3 | 2117.55
57050708 | 1214971128 | 2010-12-14 00:00:00 | TAXES 40007425 CITY OF TROY [PHONE] | 3 | 697.28
57050708 | 1214971129 | 2010-12-14 00:00:00 | TAXES 40007425 CITY OF TROY [PHONE] | 3 | 697.28
57050708 | 1214971130 | 2010-12-14 00:00:00 | TAXES 40007425 CITY OF TROY [PHONE] | 3 | 697.28
57050708 | 1214971131 | 2010-12-14 00:00:00 | TAXES 40007425 CITY OF TROY [PHONE] | 3 | 697.28
57050708 | 1214971132 | 2010-12-14 00:00:00 | TAXES 40007425 CITY OF TROY [PHONE] | 3 | 697.28
57050708 | 1214971133 | 2010-12-14 00:00:00 | TAXES 40007425 CITY OF TROY [PHONE] | 3 | 697.28
57050708 | 606970383 | 2011-06-06 00:00:00 | 40007425 hanson Construction Walnut Forest 3rd draw Nickel Consultants | 3 | 14850
57050708 | 824971245 | 2011-08-24 00:00:00 | 40007425 hanson CITY OF TROY | 3 | 2002.67
57050708 | 830971124f | 2011-08-30 00:00:00 | 40007425 | 3 | 310.87
57050708 | 1026970362 | 2011-10-26 00:00:00 | 40007425 hanson Construction | 1 | 2002.67
57050708 | 1027970090 | 2011-10-27 00:00:00 | 40007425 hanson Construction | 3
57050708 | 1030971613 | 2011-10-28 00:00:00 | 40007425 40005205 OAKLAND COUNTY TREASURER EAO0028324 | 3 | 3
57050708 | 1211971576 | 2011-12-09 00:00:00 | 40007425 CITY OF TROY [PHONE] | 3 | 735.95
57050708 | 1211971577 | 2011-12-09 00:00:00 | 40007425 CITY OF TROY [PHONE] | 3 | 735.95
57050708 | 1211971578 | 2011-12-09 00:00:00 | 40007425 CITY OF TROY [PHONE] | 3 | 735.95
57050708 | 1211971579 | 2011-12-09 00:00:00 | 4007425 CITY OF TROY [PHONE] | 3 | 735.95
57050708 | 1211971580 | 2011-12-09 00:00:00 | 40007425 CITY OF TROY [PHONE] | 3 | 735.95
57050708 | 1211971581 | 2011-12-09 00:00:00 | 4007425 CITY OF TROY [PHONE] | 3 | 735.95
57050708 | 1211971582 | 2011-12-09 00:00:00 | 4007425 CITY OF TROY [PHONE] | 3 | 735.95
57050708 | 1211971583 | 2011-12-09 00:00:00 | 4007425 CITY OF TROY [PHONE] | 3 | 735.95
57050708 | 1211971584 | 2011-12-09 00:00:00 | 4007425 CITY OF TROY [PHONE] | 3 | 735.95
57050708 | 318971040 | 2012-03-16 00:00:00 | 40007425  hanson CONSTRUCTION  LOT #6 | 1 | 150
57050708 | 405971061 | 2012-04-05 00:00:00 | 40007425 INTEGRA REALTY RESOURCES 12.023R | 3 | 350