Spreadsheet: 74383d1274898885-excel-2007-sum-account-in-specific-period-example-1-
Sheet: Sheet1

 |  | %,[NAME],[NAME],FACCOUNTING_PERIOD,B | %,[NAME],[NAME],FACCOUNT,B | %,[NAME],[NAME],FMONETARY_AMOUNT,B |  | %,[NAME],[NAME],FBUDGET_REF,B
 | I want find sum of the Monetary Amounts for each account by month (October = 1, November =2, etc)
 |  | October (Period 1) | November Period 2 | December Period 3
 | Expense:
 | Reg Staff Payroll (5121)
 | FL-Staff (5123)
 | Benefits (5129)
 | Operation (5200-6500)
 | Total Expense: |  |  |  | 5351
 |  |  |  |  | 5351
%,OH | Period | Acct | Monetary Amount
 |  |  | 43531
%,OA | 1 | 5351 | 9508
 | 1 | 5129 | 15002
 | 1 | 5129 | 30597
 | 1 | 5129 | 14776
 | 1 | 5121 | 20550
 | 1 | 5121 | 34256
 | 1 | 5129 | 45717
 | 1 | 5121 | 39131
 | 1 | 5121 | 25517
 | 1 | 5129 | 2397
 | 1 | 5129 | 35182
 | 1 | 5121 | 30865
 | 1 | 5129 | 21633
 | 1 | 5121 | 22821
 | 1 | 5121 | 40656
 | 1 | 5121 | 2188
 | 1 | 5129 | 31711
 | 1 | 5338 | 23929
 | 1 | 5334 | 41555
 | 1 | 5351 | 17401
 | 1 | 4458 | 30365
 | 1 | 5365 | 4608
 | 2 | 5121 | 47161
 | 2 | 5121 | 43821
 | 2 | 5121 | 16842
 | 2 | 5121 | 13117
 | 2 | 5129 | 18001
 | 2 | 5129 | 8669
 | 2 | 5129 | 11258
 | 2 | 5129 | 38781
 | 2 | 5371 | 41657
 | 2 | 5333 | 30355
 | 2 | 5931 | 14875
 | 2 | 5129 | 28447
 | 2 | 5121 | 38967
 | 2 | 5129 | 1745
 | 2 | 5129 | 5903
 | 2 | 5121 | 41325
 | 2 | 5121 | 47810
 | 2 | 5121 | 28957
 | 2 | 5129 | 16500
 | 2 | 5213 | 7839
 | 2 | 5338 | 47465
 | 2 | 5334 | 10727
 | 2 | 5365 | 40756
 | 2 | 5351 | 17332
 | 2 | 5351 | 44049
 | 2 | 4458 | 31358
 | 2 | 4458 | 29926
 | 3 | 5121 | 46114
 | 3 | 5121 | 30736
 | 3 | 5121 | 36859
 | 3 | 5121 | 11950
 | 3 | 5129 | 4619
 | 3 | 5129 | 17938
 | 3 | 5129 | 35486
 | 3 | 5129 | 15872
 | 3 | 5371 | 915
 | 3 | 5333 | 40985
 | 3 | 5129 | 13892
 | 3 | 5129 | 22140
 | 3 | 5129 | 44965
 | 3 | 5129 | 23643
 | 3 | 5121 | 36355
 | 3 | 5121 | 28482
 | 3 | 5121 | 42493
 | 3 | 5121 | 6675
 | 3 | 5371 | 29399
 | 3 | 5129 | 39024
 | 3 | 5129 | 20945
 | 3 | 5129 | 16698
 | 3 | 5129 | 45098
 | 3 | 5121 | 25002
 | 3 | 5121 | 4702
 | 3 | 5121 | 21799
 | 3 | 5121 | 29071
 | 3 | 5365 | 45207
 | 3 | 5334 | 19020
 | 3 | 5338 | 31693
 | 3 | 5351 | 22227
 | 3 | 5351 | 15243
 | 3 | 6431 | 30519
 | 3 | 4458 | 30924
 | 3 | 4458 | 18473
 | 4 | 5333 | 4116
 | 4 | 5129 | 43770
 | 4 | 5129 | 26032
 | 4 | 5121 | 5715
 | 4 | 5129 | 30697
 | 4 | 5121 | 9859
 | 4 | 5129 | 3730
 | 4 | 5121 | 27880
 | 4 | 5121 | 3140
 | 4 | 5371 | 24987
 | 4 | 5121 | 45304
 | 4 | 5121 | 7626
 | 4 | 5121 | 4152
 | 4 | 5121 | 44918
 | 4 | 5129 | 35108
 | 4 | 5129 | 24540
 | 4 | 5129 | 25720
 | 4 | 5129 | 39301
 | 4 | 5338 | 46299
 | 4 | 5334 | 4892
 | 4 | 5365 | 40095
 | 4 | 5351 | 8030
 | 4 | 5351 | 23581
 | 4 | 4458 | 750
 | 4 | 4458 | 27580
 | 5 | 5121 | 26738
 | 5 | 5121 | 11784
 | 5 | 5121 | 30786
 | 5 | 5121 | 10185
 | 5 | 5121 | 38493
 | 5 | 5129 | 42212
 | 5 | 5129 | 2947
 | 5 | 5129 | 44814
 | 5 | 5129 | 22995
 | 5 | 5129 | 2998
 | 5 | 5371 | 44155
 | 5 | 5121 | 17631
 | 5 | 5121 | 39027
 | 5 | 5121 | 28742
 | 5 | 5129 | 12588
 | 5 | 5121 | 37998
 | 5 | 5129 | 44131
 | 5 | 5129 | 27354
 | 5 | 5129 | 13808
 | 5 | 5129 | 1861
 | 5 | 5333 | 39509
 | 5 | 5121 | 38718
 | 5 | 5365 | 21634
 | 5 | 5334 | 37323
 | 5 | 5338 | 37810
 | 5 | 5351 | 38857
 | 5 | 4458 | 45896
 | 5 | 4458 | 9286
 | 6 | 4456 | 6726
 | 6 | 5121 | 1349
 | 6 | 5129 | 25367
 | 6 | 5129 | 21848
 | 6 | 5121 | 36370
 | 6 | 5121 | 45299
 | 6 | 5129 | 10146
 | 6 | 5121 | 44314
 | 6 | 5121 | 12969
 | 6 | 5129 | 12333
 | 6 | 5129 | 34051
 | 6 | 5333 | 5576
 | 6 | 5333 | 33288
 | 6 | 5371 | 24359
 | 6 | 5129 | 7273
 | 6 | 5129 | 35820
 | 6 | 5129 | 19033
 | 6 | 5129 | 45846
 | 6 | 5121 | 16671
 | 6 | 5121 | 3875
 | 6 | 5121 | 7800
 | 6 | 5121 | 5023
 | 6 | 5121 | 27476
 | 6 | 5129 | 44614
 | 6 | 5351 | 34359
 | 6 | 5351 | 33507
 | 6 | 5334 | 9741
 | 6 | 5338 | 37185
 | 6 | 5365 | 22771
 | 6 | 5213 | 11051
 | 6 | 4458 | 28828
 | 6 | 4458 | 22989
 | 6 | 5129 | 15329
 | 6 | 5121 | 33378
 | 7 | 5129 | 42603
 | 7 | 5121 | 17922
 | 7 | 5121 | 35347
 | 7 | 5121 | 24368
 | 7 | 5129 | 39214
 | 7 | 5121 | 41193
 | 7 | 5129 | 21307
 | 7 | 5129 | 11937
 | 7 | 5129 | 2428
 | 7 | 5121 | 22588
 | 7 | 5333 | 47808
 | 7 | 5371 | 14500
 | 7 | 5129 | 3270
 | 7 | 5129 | 25730
 | 7 | 5129 | 42932
 | 7 | 5129 | 17431
 | 7 | 5121 | 20407
 | 7 | 5129 | 39924
 | 7 | 5121 | 33023
 | 7 | 5121 | 22731
 | 7 | 5121 | 2729
 | 7 | 5121 | 24324
 | 7 | 5365 | 32047
 | 7 | 5338 | 4178
 | 7 | 5334 | 16592
 | 7 | 5351 | 7448
 | 7 | 5351 | 3322
 | 7 | 4458 | 42311
 | 7 | 4458 | 989
 | 8 | 5121 | 46982
 | 8 | 5121 | 47003
 | 8 | 5129 | 38359
 | 8 | 5129 | 10825
 | 8 | 5129 | 42445
 | 8 | 5129 | 17317
 | 8 | 5129 | 43045
 | 8 | 5121 | 24584
 | 8 | 5121 | 37901
 | 8 | 5121 | 21455
 | 8 | 5621 | 27334
 | 8 | 5333 | 22762
 | 8 | 5371 | 26576
 | 8 | 5121 | 28102
 | 8 | 5121 | 4111
 | 8 | 5121 | 4512
 | 8 | 5121 | 5786
 | 8 | 5129 | 39576
 | 8 | 5129 | 19034
 | 8 | 5129 | 40169
 | 8 | 5129 | 24994
 | 8 | 5129 | 5205
 | 8 | 5121 | 24059
%,OT | 4 | 5351 | 38640