Spreadsheet: 97154d1296398377-selecting-and-summarising-random-repeats-sample
Sheet: Sales

[NAME] shift+N |  | Next Job no | SUBTOTAL | 13536.18 | 1343.5 | 514.8199999999999 | 1013.42 | 1129 | 9535.02 | 4001.16
 |  | 155 | GRAND TOTAL | 13536.18 | 1343.5 | 514.8199999999999 | 1013.42 | 1129 | 9535.02 | 4001.16
 |  |  |  |  | Number of Days
Month | Date | Job No | CUSTOMER | Invoice Value | <30 | 30-60 | 60-90 | >90 | Actual Amount Paid | Invoices not yet paid
2010-05-24 00:00:00 | 2010-05-24 00:00:00 | 110 | A | 762.5 |  |  |  |  | 762.5 | 0
2010-06-06 00:00:00 | 2010-06-06 00:00:00 | 123 | B | 189.64 |  |  |  |  | 189.64 | 0
2010-06-07 00:00:00 | 2010-06-07 00:00:00 | 113 | C | 208 |  |  |  |  | 208 | 0
2010-09-06 00:00:00 | 2010-09-06 00:00:00 | 111 | D | 283 |  |  |  |  | 283 | 0
2010-09-16 00:00:00 | 2010-09-16 00:00:00 | 112 | E | 89 |  |  |  |  | 89 | 0
2010-10-20 00:00:00 | 2010-10-20 00:00:00 | 115 | F | 242.42 |  |  |  |  | 242.42 | 0
2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 139 | D | 327.25 |  | 327.25 |  |  |  | 327.25
2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 140 | D | 187.57 |  | 187.57 |  |  |  | 187.57
2010-12-18 00:00:00 | 2010-12-18 00:00:00 | 124 | I | 1280 |  |  |  |  | 1280 | 0
2010-12-20 00:00:00 | 2010-12-20 00:00:00 | 121 | J | 100 |  |  |  |  | 100 | 0
2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 116 | K | 270 |  |  |  |  | 270 | 0
2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 117 | L | 297 |  |  |  |  | 297 | 0
2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 118 | M | 153 |  |  |  |  | 153 | 0
2010-10-04 00:00:00 | 2010-10-04 00:00:00 | 149 | E | 297 |  |  |  | 297 |  | 297
2011-01-07 00:00:00 | 2011-01-07 00:00:00 | 120 | O | 327.25 |  |  |  |  | 327.25 | 0
2011-01-17 00:00:00 | 2011-01-17 00:00:00 | 122 | P | 187.57 |  |  |  |  | 187.57 | 0
2010-11-05 00:00:00 | 2010-11-05 00:00:00 | 150 | E | 153 |  |  | 153 |  |  | 153
2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 126 | R | 189.64 |  |  |  |  | 189.64 | 0
2010-11-01 00:00:00 | 2010-11-01 00:00:00 | 114 | G | 235 |  |  |  | 235 |  | 235
2010-09-03 00:00:00 | 2010-09-03 00:00:00 | 128 | T | 283 |  |  |  |  | 283 | 0
2010-11-18 00:00:00 | 2010-11-18 00:00:00 | 127 | H | 321 |  |  | 321 |  |  | 321
2010-11-18 00:00:00 | 2010-11-18 00:00:00 | 136 | H | 297 |  |  | 297 |  |  | 297
2010-04-01 00:00:00 | 2010-04-01 00:00:00 | 131 | W | 235 |  |  |  |  | 235 | 0
2010-09-06 00:00:00 | 2010-09-06 00:00:00 | 132 | X | 321 |  |  |  |  | 321 | 0
2010-09-16 00:00:00 | 2010-09-16 00:00:00 | 133 | Y | 1280 |  |  |  |  | 1280 | 0
2010-04-04 00:00:00 | 2010-04-04 00:00:00 | 154 | H | 150 |  |  |  | 150 |  | 150
2010-11-01 00:00:00 | 2010-11-01 00:00:00 | 135 | F | 270 |  |  |  |  | 270 | 0
2011-01-06 00:00:00 | 2011-01-06 00:00:00 | 119 | N | 25 | 25 |  |  |  |  | 25
2010-12-18 00:00:00 | 2010-12-18 00:00:00 | 137 | U | 153 |  |  |  |  | 153 | 0
2010-12-20 00:00:00 | 2010-12-20 00:00:00 | 138 | T | 25 |  |  |  |  | 25 | 0
2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 125 | Q | 762.5 | 762.5 |  |  |  |  | 762.5
2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 145 | R | 321 | 321 |  |  |  |  | 321
2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 141 | V | 283 |  |  |  |  | 283 | 0
2011-01-06 00:00:00 | 2011-01-06 00:00:00 | 142 | B | 89 |  |  |  |  | 89 | 0
2011-01-07 00:00:00 | 2011-01-07 00:00:00 | 143 | J | 242.42 |  |  |  |  | 242 | 0.4199999999999875
2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 127 | S | 208 |  |  |  | 208 |  | 208
2010-04-02 00:00:00 | 2010-04-02 00:00:00 | 152 | T | 50 |  |  |  | 50 |  | 50
2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 146 | D | 1280 |  |  |  |  | 1280 | 0
2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 147 | S | 100 |  |  |  |  | 100 | 0
2010-09-03 00:00:00 | 2010-09-03 00:00:00 | 148 | A | 270 |  |  |  |  | 270 | 0
2010-10-04 00:00:00 | 2010-10-04 00:00:00 | 129 | U | 89 |  |  |  | 89 |  | 89
2011-01-17 00:00:00 | 2011-01-17 00:00:00 | 144 | U | 235 | 235 |  |  |  |  | 235
2010-04-01 00:00:00 | 2010-04-01 00:00:00 | 151 | R | 25 |  |  |  |  | 25 | 0
2010-11-05 00:00:00 | 2010-11-05 00:00:00 | 130 | V | 242.42 |  |  | 242.42 |  |  | 242.42
2010-04-03 00:00:00 | 2010-04-03 00:00:00 | 153 | A | 100 |  |  |  |  | 100 | 0
2010-10-20 00:00:00 | 2010-10-20 00:00:00 | 134 | Z | 100 |  |  |  | 100 |  | 100
 |  |  | Subtotals | 13536.18 | 1343.5 | 514.8199999999999 | 1013.42 | 1129 | 9535.02 | 4001.16
 |  |  | check total | 13535.76