Spreadsheet: 83701d1283726784-excel-2007-count-number-of-transaction-in-a-month-when-date-is-entered-also-total-bonustracker-1-
Sheet: Sheet1

Name | Start Date | DA #1 | Street 1 | close date 1 | Bonus $ 1 | Posted 1
George | 2010-04-02 00:00:00 | 9451 | Franklin | 2010-01-17 00:00:00 | 128 | 2010-01-19 00:00:00
Fred | 2010-01-03 00:00:00 | 9452 | Balley Castle | 2010-02-13 00:00:00 | 345 | 2010-02-13 00:00:00
[NAME] | 2010-07-25 00:00:00 | 9458 | Renfro | 2010-08-23 00:00:00 | 298 | 2010-08-24 00:00:00 |  |  | Row Labels | Sum of Bonus $ 1 | Count of Bonus $ 1 |  |  | Sum of Bonus $ 1 | Column Labels
[NAME] | 2010-07-03 00:00:00 | 9460 | SW 3rd | 2010-08-28 00:00:00 | 672 | 2010-09-03 00:00:00 |  |  | <1/19/2010 |  |  |  |  | Row Labels | [NAME] | Debbie | Fred | George | [NAME] | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Grand Total
[NAME] | 2010-05-29 00:00:00 | 9463 | Lions Gate | 2010-07-03 00:00:00 | 111 | 2010-07-03 00:00:00 |  |  | (blank) | 1626 | 7 |  |  | 2010-01-17 00:00:00 |  |  |  | 384 |  |  |  |  |  |  |  | 384
[NAME] | 2010-08-14 00:00:00 | 9465 | [NAME] | 2010-09-22 00:00:00 | 394 |  |  |  | Fred | 111 | 1 |  |  | 2010-02-13 00:00:00 |  |  | 1035 |  |  |  |  |  |  |  |  | 1035
Debbie | 2010-03-05 00:00:00 | 9466 | Saint George | 2010-03-30 00:00:00 | 235 | 2010-03-29 00:00:00 |  |  | [NAME] | 333 | 3 |  |  | 2010-02-15 00:00:00 |  |  |  |  |  |  | 894 |  |  |  | 298 | 1192
Jake | 2010-06-05 00:00:00 |  |  | 2010-06-30 00:00:00 |  | 2010-06-30 00:00:00 |  |  | [NAME] | 1182 | 3 |  |  | 2010-03-19 00:00:00 |  |  |  | 324 |  |  |  |  |  | 972 |  | 1296
[NAME] | 2010-02-08 00:00:00 | 9469 | Stella | 2010-03-19 00:00:00 | 324 | 2010-03-20 00:00:00 |  |  | 2010 |  |  |  |  | 2010-03-30 00:00:00 |  | 705 |  |  |  |  |  |  |  |  |  | 705
[NAME] | 2010-09-11 00:00:00 | 9470 | Easy | 2010-10-25 00:00:00 | 111 |  |  |  | Jan | 384 | 3 |  |  | 2010-06-30 00:00:00
[NAME] | 2010-01-02 00:00:00 | 9471 | Harvest Hill | 2010-02-15 00:00:00 | 298 | 2010-02-17 00:00:00 |  |  | George | 384 | 3 |  |  | 2010-07-03 00:00:00 |  |  |  |  |  |  |  |  | 333 |  |  | 333
George | 2010-04-02 00:00:00 | 9451 | Franklin | 2010-01-17 00:00:00 | 128 | 2010-01-19 00:00:00 |  |  | Feb | 2227 | 7 |  |  | 2010-08-23 00:00:00 |  |  |  |  |  |  |  |  |  |  | 894 | 894
Fred | 2010-01-03 00:00:00 | 9452 | Balley Castle | 2010-02-13 00:00:00 | 345 | 2010-02-13 00:00:00 |  |  | Fred | 1035 | 3 |  |  | 2010-08-28 00:00:00 | 2016 |  |  |  |  |  |  |  |  |  |  | 2016
[NAME] | 2010-07-25 00:00:00 | 9458 | Renfro | 2010-08-23 00:00:00 | 298 | 2010-08-24 00:00:00 |  |  | [NAME] | 894 | 3 |  |  | 2010-09-22 00:00:00 |  |  |  |  |  |  |  | 1182 |  |  |  | 1182
[NAME] | 2010-07-03 00:00:00 | 9460 | SW 3rd | 2010-08-28 00:00:00 | 672 | 2010-09-03 00:00:00 |  |  | [NAME] | 298 | 1 |  |  | 2010-10-25 00:00:00 |  |  | 111 |  | 333 |  |  |  |  |  |  | 444
[NAME] | 2010-05-29 00:00:00 | 9463 | Lions Gate | 2010-07-03 00:00:00 | 111 | 2010-07-03 00:00:00 |  |  | Mar | 2001 | 7 |  |  | Grand Total | 2016 | 705 | 1146 | 708 | 333 |  | 894 | 1182 | 333 | 972 | 1192 | 9481
[NAME] | 2010-08-14 00:00:00 | 9465 | [NAME] | 2010-09-22 00:00:00 | 394 |  |  |  | Debbie | 705 | 3
Debbie | 2010-03-05 00:00:00 | 9466 | Saint George | 2010-03-30 00:00:00 | 235 | 2010-03-29 00:00:00 |  |  | George | 324 | 1
Jake | 2010-06-05 00:00:00 |  |  | 2010-06-30 00:00:00 |  | 2010-06-30 00:00:00 |  |  | [NAME] | 972 | 3
[NAME] | 2010-02-08 00:00:00 | 9469 | Stella | 2010-03-19 00:00:00 | 324 | 2010-03-20 00:00:00 |  |  | Jun
[NAME] | 2010-09-11 00:00:00 | 9470 | Easy | 2010-10-25 00:00:00 | 111 |  |  |  | Jake
[NAME] | 2010-01-02 00:00:00 | 9471 | Harvest Hill | 2010-02-15 00:00:00 | 298 | 2010-02-17 00:00:00 |  |  | Jul | 333 | 3
George | 2010-04-02 00:00:00 | 9451 | Franklin | 2010-01-17 00:00:00 | 128 | 2010-01-19 00:00:00 |  |  | [NAME] | 333 | 3
Fred | 2010-01-03 00:00:00 | 9452 | Balley Castle | 2010-02-13 00:00:00 | 345 | 2010-02-13 00:00:00 |  |  | Aug | 894 | 3
[NAME] | 2010-07-25 00:00:00 | 9458 | Renfro | 2010-08-23 00:00:00 | 298 | 2010-08-24 00:00:00 |  |  | [NAME] | 894 | 3
[NAME] | 2010-07-03 00:00:00 | 9460 | SW 3rd | 2010-08-28 00:00:00 | 672 | 2010-09-03 00:00:00 |  |  | Sep | 2016 | 3
[NAME] | 2010-05-29 00:00:00 | 9463 | Lions Gate | 2010-07-03 00:00:00 | 111 | 2010-07-03 00:00:00 |  |  | [NAME] | 2016 | 3
[NAME] | 2010-08-14 00:00:00 | 9465 | [NAME] | 2010-09-22 00:00:00 | 394 |  |  |  | Grand Total | 9481 | 33
Debbie | 2010-03-05 00:00:00 | 9466 | Saint George | 2010-03-30 00:00:00 | 235 | 2010-03-29 00:00:00
Jake | 2010-06-05 00:00:00 |  |  | 2010-06-30 00:00:00 |  | 2010-06-30 00:00:00
[NAME] | 2010-02-08 00:00:00 | 9469 | Stella | 2010-03-19 00:00:00 | 324 | 2010-03-20 00:00:00
[NAME] | 2010-09-11 00:00:00 | 9470 | Easy | 2010-10-25 00:00:00 | 111
[NAME] | 2010-01-02 00:00:00 | 9471 | Harvest Hill | 2010-02-15 00:00:00 | 298 | 2010-02-17 00:00:00
George | 2010-04-02 00:00:00 | 9469 | Stella | 2010-03-19 00:00:00 | 324 | 2010-03-20 00:00:00
Fred | 2010-01-03 00:00:00 | 9470 | Easy | 2010-10-25 00:00:00 | 111
[NAME] | 2010-07-25 00:00:00 | 9471 | Harvest Hill | 2010-02-15 00:00:00 | 298 | 2010-02-17 00:00:00