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

 |  |  |  |  |  |  | ACCOUNT | FMS ITEM ADDRESS | DATE | [NAME] | TRAN CODE | TRANSACTION AMOUNT |  |  |  |  |  |  |  | Input GL ME balance after you pull in the GL tranhist
1 | credit | regular |  |  |  |  | 18049008 | 503850005 | 2012-05-03 00:00:00 | RECOVERIES 50% RECOVERIES FDIC | 1 | 39.53 |  |  |  |  |  |  |  | 2010-09-30 00:00:00 | 2055161.35
2 | credit | list post |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-30 00:00:00 | 2571276.53
3 | debit | regular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-11-30 00:00:00 | 3126030.66
4 | debit | list post |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-12-30 00:00:00 | 3319588.75
5 | credit | EOY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-30 00:00:00 | 3482411.25
6 | debit | EOY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-28 00:00:00 | 2975824.86
7 | credit | Off ledger |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-30 00:00:00 | 2708377.29
8 | debit | Off ledger |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-04-30 00:00:00 | 2435746.68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-05-30 00:00:00 | 3375526
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-06-30 00:00:00 | 2705450.18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-30 00:00:00 | 2828881.58
Use Insyte report: mml GL tranhist-enter GL number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-30 00:00:00 | 2557766.03
create own tab and then copy into running data tab |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-30 00:00:00 | -82764.72
In Data, select [NAME].  Click Unselect All and then click FMS Item Address and say OK (only had dups one month…..looks like this won't be a problem. U can tell if it is by the month end running balance) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-30 00:00:00 | 1145.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-30 00:00:00 | -29076.68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-30 00:00:00 | 196300.53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-30 00:00:00 | 242184.21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-29 00:00:00 | 191497.42
18049008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-30 00:00:00 | 370138.56
27930008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-30 00:00:00 | 270723.54
48012008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-30 00:00:00
48013008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-30 00:00:00
48020008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-30 00:00:00
48021008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-30 00:00:00
48097008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-30 00:00:00
48098008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-30 00:00:00
56041608 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-30 00:00:00
56041708 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-30 00:00:00
57050108 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-30 00:00:00
57050208 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-28 00:00:00
57050508 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-30 00:00:00
57050608 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-04-30 00:00:00
57050708 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-06-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-07-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-08-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-30 00:00:00
40006960 | taft knolls
40007415 | galliers
40003650 | [NAME]
40009050 | ashka
40006535 | nca 825 clyde
40006625 | west a
40004770 | ryder
40009410 | shamberger
40006420 | rea
40008160 | purgo
40001610 | menard
2140009875 | damas
40007985 | buschmohle
40010490 | jabara
40009875 | damas
40009775 | little italy
40009070 | fair
40009070 | fair
40004855 | gs sabre
40004855 | gs sabre
40009000 | oxprop
40009000 | oxprop
2240006710 | main
40008285 | moss construction
40010570 | michigan windshield
40007765 | [NAME] brothers
40008285 | moss construction
40009190 | rs acquisition
40001675 | richardson
40009445 | rs acquisition b
40009610 | r&r miller holdings
40009235 | [NAME] a
40009880 | havana
40007885 | [NAME]
40006120 | nca 32656 florence
40006290 | nca 21827 brittany
40007105 | key group a
40009015 | charara
40007225 | key group b
40008610 | papazian todd
40009225 | plymouth supercenter
40007865 | welsh a
40007745 | euro masonry
40007745 | euro masonry
40007745 | euro masonry
40007545 | hoover
40003650 | [NAME]
40005065 | [NAME] a
40004955 | macrae
40004955 | macrae
40007620 | saputo b
40007620 | saputo b
40007620 | saputo b
40007470 | saputo a
40007430 | papazian mark
40003860 | d&b investment
40003860 | d&b investment
40003860 | d&b investment
40006100 | nca 2340 mckinley
40006100 | nca 2340 mckinley
40007430 | papazian mark
40003860 | d&b investment
40003860 | d&b investment
40003860 | d&b investment
40006865 | davison
40009085 | gods grace b
40005190 | [NAME] b
40008535 | pro athletic
40007815 | phillips lawn care a
40008535 | pro athletic
40008280 | phillips lawn care c
40007820 | phillips lawn care b
40007820 | phillips lawn care b
40007815 | phillips lawn care a
40005190 | [NAME] b
40009085 | gods grace b
40004710 | [NAME]
40009070 | fair
40007745 | euro masonry
40004855 | gs sabre
40004855 | gs sabre
40009035 | phillips lawn care d
40007985 | buschmohle
40010495 | gerish & meeks
40007315 | canton 1
40010495 | gerish & meeks
40004710 | [NAME]
40008040 | papazian [NAME]
40008105 | genesis sand
40008535 | pro athletic
40008650 | papazian [NAME]
40009000 | oxprop
40009070 | fair
40010570 | michigan windshield
40009880 | havana
40009880 | havana
40010025 | moceri
40010025 | moceri
40008105 | genesis sand
40008535 | pro athletic
40008740 | breslin
40008740 | breslin
40008740 | breslin
40007430 | papazian mark
40007470 | saputo a
40007470 | saputo a
40003115 | medoro
40009690 | clean art
40009690 | clean art
40009690 | clean art
40009020 | trailhead
40009020 | trailhead
40009235 | [NAME] a
1000005643 | moyers
40008565 | alliance printing b
40008565 | alliance printing b
40004600 | jason
40004600 | jason
40008565 | alliance printing b
40008565 | alliance printing b
40008565 | alliance printing b
40008565 | alliance printing b
40009000 | oxprop
40007225 | key group b
40007620 | saputo b
40009035 | phillips lawn care d
40010480 | class act
40009876 | damas
1000005643 | moyers
40007745 | euro masonry
40010495 | gerish & meeks
1000005643 | moyers
40009690 | clean art
40010495 | gerish & meeks
40010025 | moceri
40010025 | moceri
40009880 | havana
40009880 | havana
40009880 | havana
40009880 | havana
40009880 | havana
40009880 | havana
40009275 | fedo
40009275 | fedo
40004710 | [NAME]
40004710 | [NAME]
40004710 | [NAME]
40004710 | [NAME]
40004710 | [NAME]
40004710 | [NAME]
40009875 | damas
40009875 | damas
40009875 | damas
40009875 | damas
40009875 | damas
40003115 | medoro
40009275 | fedo
40009275 | fedo
40009275 | fedo
40009275 | fedo
40009275 | fedo
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
40006160 | kuffner
40006160 | kuffner
40006160 | kuffner
40006160 | kuffner
40006160 | kuffner
40006160 | kuffner
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
40007590 | pinetree
40008675 | papazian mark
40009000 | oxprop
40004600 | jason
40006160 | kuffner
40006160 | kuffner
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
40006930 | [NAME]
40006930 | [NAME]
40007634 | calisti
40007634 | calisti
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
2240006710 | main
40004710 | [NAME]
40004710 | [NAME]
40008285 | moss construction
40008285 | moss construction
40005765 | plymouth concrete
40005765 | plymouth concrete
1000004703 | sweeney
1000004703 | sweeney
 | [NAME]
40008280 | phillips lawn care c
40008280 | phillips lawn care c
40008290 | mt moria church
40009325 | gods grace c
40009325 | gods grace c
40006230 | nca 23260 berkley
201062 | papazian [NAME]
40008820 | samouelian
2240006710 | main
40003650 | [NAME]
40003650 | [NAME]
40004600 | jason
40004600 | jason
40004600 | jason
40006160 | kuffner
40009265 | medina
40004600 | jason
40009070 | fair
40010570 | michigan windshield
201062 | papazian [NAME]
40009070 | fair
40009070 | fair
40007950 | [NAME]
40007950 | [NAME]
40009235 | [NAME]
40007725 | west b
40007725 | west b
2240006710 | main
40006160 | kuffner
40009070 | fair
40009070 | fair
40009265 | medina
40010570 | michigan windshield
201062 | papazian [NAME]
40006960 | taft knolls
40006960 | taft knolls
40005205 | pratt building
40005205 | pratt building
40007425 | [NAME]
40007425 | [NAME]
 | bernard
40009280 | finny mccool
40009065 | komorn b
40009065 | komorn b
40008145 | komorn a
40008145 | komorn a
2140009235 | [NAME] b
40006700 | nca 3922 britton
40007590 | pinetree