Spreadsheet: 181715d1348130196-sumif-and-subtotal-sample-customer-spreadsheet
Sheet: Customers

 | Total active customers | 29 |  |  |  |  |  |  |  | 1 = Std 2 = Grn 3 = Dairy 4 = Lrg 5 = Other
Acc. No. | Name | Half std | Standard | Green | Dairy | Large | Extra veg | Cheese | Eggs | Holiday this wk? | Delivery week | Delivery route | Joined | Left
1 | [NAME] Stocks |  | 5.75 |  |  |  |  |  | 1.25 |  | 1,2,3,4 | B
2 | [NAME] |  |  | 8.25 |  |  |  |  |  |  | 1,2,3,4 | B |  | 2012-03-30 00:00:00
5 | [NAME] |  |  |  |  | 10.75 |  |  |  |  | 2,4 | B |  | 2012-05-30 00:00:00
8 | [NAME] |  |  |  |  | 10 |  |  |  |  | 1,2,3,4 | B |  | 2012-02-04 00:00:00
7 | [NAME] |  | 5.75 |  |  |  |  |  | 1.25 |  | 1,2,3,4 | B | 2012-03-02 00:00:00
9 | Peta Levantis |  |  | 8.25 |  |  |  |  | 1.25 |  | 1,2,3,4 | A
11 | [NAME] |  | 5 |  |  |  |  |  |  |  | 1,3 | B |  | 2012-02-03 00:00:00
10 | [NAME] |  | 5.75 |  |  |  |  |  | 1.25 | 1 | 1,2,3,4 | A
13 | [NAME] | 3.25 |  |  |  |  |  |  |  |  | 1,3 | B |  | 2012-03-13 00:00:00
14 | Doreen Hunt | 2.5 |  |  |  |  |  |  |  |  | 1,3 | B
16 | [NAME] |  | 5.75 |  |  |  |  |  |  |  | 1,3 | B
17 | [NAME] |  |  |  | 9.75 |  |  |  |  |  | 1,3 | B
19 | [NAME] |  | 5.75 |  |  |  |  |  |  |  | 1,3 | A
21 | [NAME] |  |  | 8.25 |  |  |  |  |  | 2 | 1 | C | 2012-01-27 00:00:00
22 | [NAME] |  | 5 |  |  |  |  |  | 2.5 |  | 1,2,3,4 | C | 2012-01-20 00:00:00
23 | [NAME] |  | 5.75 |  |  |  |  |  |  |  | 1,3 | B | 2012-01-27 00:00:00
25 | [NAME] |  |  |  | 9.75 |  |  |  |  |  | 1,2,3,4 | A | 2012-01-27 00:00:00 | 2012-02-04 00:00:00
24 | [NAME] |  | 5.75 |  |  |  |  |  | 1.25 | 1 | 1,2,3,4 | A | 2012-02-03 00:00:00
26 | [NAME] |  | 5 |  |  |  |  |  | 1.25 |  | 1,2,3,4 | C | 2012-01-27 00:00:00
27 | Kat Wiggins |  |  | 8.25 |  |  |  |  | 1.25 |  | 1,2,3,4 | C | 2012-01-27 00:00:00
28 | [NAME] |  |  |  |  |  |  |  | 1.25 | 5 | 1,2,3,4 | C | 2012-01-27 00:00:00
29 | [NAME] |  | 5.75 |  |  |  |  |  |  |  | 1,2,3,4 | C | 2012-01-27 00:00:00
30 | [NAME] |  |  |  |  | 10.75 |  |  |  |  | 2,4 | A | 2012-01-27 00:00:00 | 2012-02-25 00:00:00
31 | [NAME] |  | 5 |  |  |  |  |  |  |  | 1,2 | C | 2012-02-03 00:00:00 | 2012-02-07 00:00:00
32 | [NAME] |  | 5 |  |  |  |  |  |  | 1 | 1,3 | C | 2012-01-31 00:00:00
33 | [NAME] |  |  |  |  | 10.75 |  |  |  |  | 2,4 | A | 2012-02-06 00:00:00 | 2012-03-24 00:00:00
34 | [NAME] |  |  | 8.25 |  |  |  |  |  |  | 1,2,3,4 | B | 2012-02-14 00:00:00 | 2012-06-28 00:00:00
35 | [NAME] |  |  |  | 9.75 |  |  |  |  |  | 1,2,3,4 | C | 2012-02-19 00:00:00
36 | [NAME] |  | 5.75 |  |  |  |  |  |  |  | 1,2,3,4 | B | 2012-03-26 00:00:00 | 2012-04-06 00:00:00
37 | [NAME] |  | 5.75 |  |  |  |  |  | 1.25 |  | 1,2,3,4 | C | 2012-04-02 00:00:00
38 | [NAME] |  | 5.75 |  |  |  |  |  |  |  | 1,3 | C | 2012-04-05 00:00:00
39 | [NAME] |  | 5.75 |  |  |  |  |  |  |  | 1,3 | B | 2012-04-07 00:00:00 | 2012-07-06 00:00:00
40 | [NAME] |  |  |  |  | 10.75 |  |  |  |  | 1,2,3,4 | A | 2012-04-24 00:00:00
41 | Rich & Bev Hunter |  | 5 |  |  |  |  |  | 1.25 |  | 1,2,3,4 | C | 2012-04-30 00:00:00
42 | [NAME] |  | 5 |  |  |  |  |  | 1.25 |  | 1,2,3,4 | C | 2012-04-30 00:00:00
43 | [NAME] |  |  |  |  |  |  |  | 1.25 |  | 1,2,3,4 | C | 2012-05-08 00:00:00
44 | [NAME] |  | 5.75 |  |  |  |  |  |  |  | 2,4 | C | 2012-05-08 00:00:00
45 | [NAME] |  |  | 8.25 |  |  | 1.25 |  | 1.25 |  | 1,2,3,4 | B | 2012-05-11 00:00:00
46 | [NAME] |  | 5.75 |  |  |  |  |  |  |  | 1,2,3,4 | C | 2012-05-16 00:00:00
47 | [NAME]'s friend! |  | 5 |  |  |  |  |  |  | 1 | 2,4 | C | 2012-05-29 00:00:00 | 2012-06-15 00:00:00
48 | Kate Yates |  |  | 8.25 |  |  |  |  | 1.25 |  | 1,3 | B | 2012-05-31 00:00:00
49 | [NAME] |  |  |  | 9 |  |  |  |  |  | 1,2,3,4 | B | 2012-06-11 00:00:00
50 | Adrian Heaven |  |  | 7.5 |  |  |  |  |  |  | 1,2,3,4 | C | 2012-06-08 00:00:00
51 | [NAME] |  |  |  |  |  |  |  | 1.25 |  | 1,2,3,4 | C | 2012-07-20 00:00:00
52 | [NAME] |  |  | 7.5 |  |  |  |  | 1.25 | 2 | 1,2,3,4 | C | 2012-07-20 00:00:00
53 | [NAME] |  |  | 7.5 |  |  |  |  | 2.5 | 2 | 1,2,3,4 | C | 2012-07-23 00:00:00
54 | [NAME] |  |  | 7.5 |  |  |  |  | 1.25 |  | 1,2,3,4 | C | 2012-08-07 00:00:00
55 | [NAME] |  | 5.75 |  |  |  |  |  |  |  | 1,2,3,4 | A | 2012-08-31 00:00:00
56 | [NAME] |  | 5 |  |  |  |  |  |  |  | 1,2,3,4 | D | 2012-08-28 00:00:00
57 | [NAME] |  |  |  |  | 10 | 1.25 | 2.75 | 1.25 |  | 1,2,3,4 | B | 2012-09-03 00:00:00
58 | [NAME] |  | 5 |  |  |  |  |  | 1.25 |  | 1,2,3,4 | C | 2012-09-16 00:00:00