Spreadsheet: 117768d1313007003-counting-within-time-frame-audit-report_test
Sheet: Sheet1

Invoice Date | Amount |  |  | Week Ending | Number of Invoices | Total Amount
2011-03-03 00:00:00 | 300 |  |  | 2011-03-04 00:00:00
2011-03-03 00:00:00 | 431.24 |  |  | 2011-03-11 00:00:00
2011-03-03 00:00:00 | 431.24 |  |  | 2011-03-18 00:00:00
2011-03-09 00:00:00 | 508130.3 |  |  | 2011-03-25 00:00:00
2011-03-11 00:00:00 | 604 |  |  | 2011-04-01 00:00:00
2011-03-15 00:00:00 | 174.63 |  |  | 2011-04-08 00:00:00
2011-03-15 00:00:00 | 32470 |  |  | 2011-04-15 00:00:00
2011-03-16 00:00:00 | 1472.72 |  |  | 2011-04-22 00:00:00
2011-03-22 00:00:00 | 12.31 |  |  | 2011-04-29 00:00:00
2011-03-22 00:00:00 | 112.29 |  |  | 2011-05-06 00:00:00
2011-03-23 00:00:00 | 8898.4 |  |  | 2011-05-13 00:00:00
2011-03-23 00:00:00 | 4075.4 |  |  | 2011-05-20 00:00:00
2011-03-25 00:00:00 | 80086.83 |  |  | 2011-05-27 00:00:00
2011-03-28 00:00:00 | 538637 |  |  | 2011-06-03 00:00:00
2011-03-31 00:00:00 | 64494.7 |  |  | 2011-06-10 00:00:00
2011-03-31 00:00:00 | 12425.59 |  |  | 2011-06-17 00:00:00
2011-03-31 00:00:00 | 2758.17 |  |  | 2011-06-24 00:00:00
2011-03-31 00:00:00 | 270.37 |  |  | 2011-07-01 00:00:00
2011-03-31 00:00:00 | 26.3 |  |  | 2011-07-08 00:00:00
2011-03-31 00:00:00 | 9794.8 |  |  | 2011-07-15 00:00:00
2011-03-31 00:00:00 | 3724.2 |  |  | 2011-07-22 00:00:00
2011-03-31 00:00:00 | 64494.7
2011-04-04 00:00:00 | 1905732
2011-04-05 00:00:00 | 950 |  |  |  | *A formula that would count the number of invoices that fall within the time frame
2011-04-07 00:00:00 | 2833
2011-04-08 00:00:00 | 2283.1 |  |  |  | *[NAME] that would total the amount of the invoices falling within the time frame
2011-04-08 00:00:00 | 13200
2011-04-08 00:00:00 | 1500
2011-04-08 00:00:00 | 2850
2011-04-08 00:00:00 | 17630
2011-04-08 00:00:00 | 256149.69
2011-04-11 00:00:00 | 600
2011-04-14 00:00:00 | 60000
2011-04-14 00:00:00 | 4312.21
2011-04-14 00:00:00 | 53900
2011-04-15 00:00:00 | 31.74
2011-04-21 00:00:00 | 3708.17
2011-04-26 00:00:00 | 116.8
2011-04-29 00:00:00 | 12.02
2011-04-29 00:00:00 | 56.85
2011-05-03 00:00:00 | 2955.75
2011-05-03 00:00:00 | 274.14
2011-05-04 00:00:00 | 449070
2011-05-04 00:00:00 | 35000
2011-05-04 00:00:00 | 2723
2011-05-05 00:00:00 | 14061.91
2011-05-05 00:00:00 | 449070
2011-05-05 00:00:00 | 587038.08
2011-05-05 00:00:00 | 85255
2011-05-05 00:00:00 | 587038.08
2011-05-05 00:00:00 | 4512.42
2011-05-06 00:00:00 | 8678.83
2011-05-06 00:00:00 | 299.6
2011-05-06 00:00:00 | 85.6
2011-05-06 00:00:00 | 114.13
2011-05-06 00:00:00 | 3333
2011-05-06 00:00:00 | 2673
2011-05-06 00:00:00 | 299.6
2011-05-06 00:00:00 | 85.6
2011-05-06 00:00:00 | 54463.54
2011-05-06 00:00:00 | 8678.83
2011-05-06 00:00:00 | 122.36
2011-05-06 00:00:00 | 114.13
2011-05-09 00:00:00 | 885.71
2011-05-09 00:00:00 | 78.28
2011-05-09 00:00:00 | 7032
2011-05-11 00:00:00 | 404056
2011-05-11 00:00:00 | 19457
2011-05-11 00:00:00 | 452301
2011-05-11 00:00:00 | 485905
2011-05-11 00:00:00 | 20165
2011-05-11 00:00:00 | 375198
2011-05-11 00:00:00 | 19457
2011-05-11 00:00:00 | 4130.45
2011-05-12 00:00:00 | 104505.19
2011-05-13 00:00:00 | 31500
2011-05-13 00:00:00 | 79669
2011-05-13 00:00:00 | 10.45
2011-05-16 00:00:00 | 1339917
2011-05-16 00:00:00 | 2170000
2011-05-16 00:00:00 | 2295500
2011-05-18 00:00:00 | 3465
2011-05-18 00:00:00 | 10391
2011-05-18 00:00:00 | 366.93
2011-05-23 00:00:00 | 54.45
2011-05-25 00:00:00 | 52162.5
2011-05-27 00:00:00 | 9794.8
2011-06-07 00:00:00 | 1160
2011-06-09 00:00:00 | 375
2011-06-09 00:00:00 | 100
2011-06-10 00:00:00 | 92.56
2011-06-10 00:00:00 | 191
2011-06-14 00:00:00 | 193420
2011-06-14 00:00:00 | 802.55
2011-06-14 00:00:00 | 78.73
2011-06-14 00:00:00 | 365.5
2011-06-14 00:00:00 | 1626
2011-06-14 00:00:00 | 1626
2011-06-14 00:00:00 | 1982.7
2011-06-14 00:00:00 | 314.92
2011-06-14 00:00:00 | 1314.32
2011-06-17 00:00:00 | 1945.7
2011-06-21 00:00:00 | 3012
2011-06-21 00:00:00 | 145.06
2011-06-30 00:00:00 | 299.8
2011-07-01 00:00:00 | 15234
2011-07-01 00:00:00 | 1725
2011-07-04 00:00:00 | 275.18
2011-07-07 00:00:00 | 39.8
2011-07-08 00:00:00 | 344778.35
2011-07-12 00:00:00 | 16412.74
2011-07-13 00:00:00 | 77.25
2011-07-18 00:00:00 | 5820
2011-07-18 00:00:00 | 67.41