Spreadsheet: 43474d1242130709-help-needed-to-create-a-formula-to-add-values-assigned-cumulative-dates-in-a-month-dateproblem
Sheet: CashBack

Date | Description | Total Amount | Sales | Cashback | Daily Total Summary
2009-04-03 00:00:00 | G Faherty | 48.6 | 8.6 | 40
2009-04-04 00:00:00 | I Sexton | 56.35 | 6.35 | 50
2009-04-05 00:00:00 | A Bell | 41.45 | 11.45 | 30
2009-04-06 00:00:00 | M Trott | 54 | 4 | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In column F I need a way of displaying the total sales (column C) for individual dates on a cumulative basis.  For example the 10th of April.  Cell F17 should include the totals of C11:C17, whereas cells F11 to F16 should remain blank.  Thank you for all your help
2009-04-06 00:00:00 | A [NAME] | 58.15 | 8.15 | 50
2009-04-08 00:00:00 | M Seaton | 28.35 | 8.35 | 20
2009-04-08 00:00:00 | D Brown | 52.45 | 2.45 | 50
2009-04-09 00:00:00 | H Mills | 50.55 | 0.55 | 50
2009-04-09 00:00:00 | I Sexton | 52.1 | 2.1 | 50
2009-04-10 00:00:00 | A Bailey | 46.5 | 6.5 | 40
2009-04-10 00:00:00 | H Mills | 52.15 | 2.15 | 50
2009-04-10 00:00:00 | T O' sullivan | 52.3 | 2.3 | 50
2009-04-10 00:00:00 | D Brown | 54.05 | 4.05 | 50
2009-04-10 00:00:00 | R B Murthy | 52.2 | 2.2 | 50
2009-04-10 00:00:00 | M Seaton | 57.95 | 7.95 | 50
2009-04-10 00:00:00 | C Hart | 58.45 | 8.45 | 50
2009-04-11 00:00:00 | P Cook | 55.35 | 5.35 | 50
2009-04-11 00:00:00 | M Hart | 67.05 | 17.05 | 50
2009-04-11 00:00:00 | I Sexton | 53.1 | 3.1 | 50
2009-04-12 00:00:00 | M Seaton | 59 | 9 | 50
2009-04-12 00:00:00 | M Barber | 5.25 | 5.25 | 0
13/04/09 | M Trott | 52.45 | 2.45 | 50
13/04/09 | D Flanders | 53.2 | 3.2 | 50
15/04/09 | B Farinha | 52.3 | 2.3 | 50
15/04/09 | M Seaton | 53.5 | 3.5 | 50
15/04/09 | C Hart | 8.25 | 8.25 | 0
15/04/09 | D Brown | 55.65 | 5.65 | 50
15/04/09 | P Mills | 52.2 | 2.2 | 50
16/04/09 | H Mills | 52.8 | 2.8 | 50
16/04/09 | M Trott | 54 | 4 | 50
16/04/09 | M Seaton | 52 | 2 | 50
16/04/09 | I Sexton | 54.3 | 4.3 | 50
17/04/09 | D Hudson | 53.1 | 3.1 | 50
17/04/09 | D Brown | 57.1 | 7.1 | 50
17/04/09 | C Dietz | 49.45 | 6.45 | 43
17/04/09 | B Farihna | 57.63 | 7.63 | 50
17/04/09 | C Hart | 57.5 | 7.5 | 50
17/04/09 | C Dietz | 53.95 | 3.95 | 50
18/04/09 | T Shurety | 54.4 | 4.4 | 50
18/04/09 | M Seaton | 55.5 | 5.5 | 50
18/04/09 | R Clarke | 49.15 | 9.15 | 40
18/04/09 | M Hart | 65.8 | 15.8 | 50
19/04/09 | I Sexton | 52.1 | 2.1 | 50
20/04/09 | D Flanders | 55.4 | 5.4 | 50
20/04/09 | M Trott | 54 | 4 | 50
21/04/09 | A [NAME] | 52.1 | 2.1 | 50
21/04/09 | B Farhina | 54.6 | 4.6 | 50
22/04/09 | B Bell | 100 | 100 | 0
23/04/09 | F Bond | 58.45 | 8.45 | 50
23/04/09 | H Mills | 20.55 | 0.55 | 20
23/04/09 | I Sexton | 54.25 | 4.25 | 50
24/04/09 | A [NAME] | 100 | 100 | 0
24/04/09 | T Davies | 56.95 | 6.95 | 50
24/04/09 | M Seaton | 55.5 | 5.5 | 50
25/04/09 | T Davies | 59.5 | 9.5 | 50
25/04/09 | H Mills | 56 | 6 | 50
25/04/09 | P Cook | 58.55 | 8.55 | 50
25/04/09 | M Seaton | 52.3 | 2.3 | 50
25/04/09 | S Foster | 52.85 | 2.85 | 50
26/04/09 | P Bickemore | 54.3 | 4.3 | 50
26/04/09 | P Mills | 52.5 | 2.5 | 50
26/04/09 | T Davies | 52.2 | 2.2 | 50
26/04/09 | A Shurety | 71.2 | 21.2 | 50
26/04/09 | I Sexton | 52.1 | 2.1 | 50
27/04/09 | D McDonald | 62.4 | 12.4 | 50
28/04/09 | M Trott | 54 | 4 | 50
29/04/09 | D Brown | 59.9 | 9.9 | 50
29/04/09 | I Sexton | 57.4 | 7.4 | 50
30/04/09 | D Mc Donald | 56.9 | 6.9 | 50
2009-05-01 00:00:00 | A Aarron | 100 | 100
2009-05-01 00:00:00 | C Hart | 58 | 8 | 50
2009-05-01 00:00:00 | K Seaton | 3 | 3
2009-05-01 00:00:00 | M Seaton | 67.2 | 17.2 | 50
2009-05-02 00:00:00 | M Seaton | 53.75 | 3.75 | 50
2009-05-03 00:00:00 | C Fawcett | 29.05 | 9.05 | 20
2009-05-03 00:00:00 | P Champion | 23.3 | 3.3 | 20
2009-05-03 00:00:00 | T Testo | 55.45 | 5.45 | 50
2009-05-03 00:00:00 | M Seaton | 67.65 | 17.65 | 50
2009-05-03 00:00:00 | M Barber | 14.55 | 4.55 | 10
2009-05-04 00:00:00 | B Thompson | 24.45 | 4.45 | 20
2009-05-04 00:00:00 | H Mills | 20.55 | 0.55 | 20
2009-05-04 00:00:00 | I Sexton | 52.1 | 2.1 | 50
2009-05-05 00:00:00 | J White | 52.35 | 2.35 | 50
2009-05-05 00:00:00 | B Springgate | 52 | 2 | 50
2009-05-06 00:00:00 | B Farinha | 52.3 | 2.3 | 50
2009-05-06 00:00:00 | P Mills | 52.2 | 2.2 | 50
2009-05-07 00:00:00 | I Sexton | 52.1 | 2.1 | 50
2009-05-08 00:00:00 | A [NAME] | 50 | 50 | 0
2009-05-08 00:00:00 | C Hart | 59.3 | 9.3 | 50
2009-05-08 00:00:00 | D Brown | 62.55 | 12.55 | 50
2009-05-08 00:00:00 | [NAME] | 52.1 | 2.1 | 50
2009-05-09 00:00:00 | B Farinha | 53.85 | 3.85 | 50
2009-05-09 00:00:00 | I Sexton | 37.85 | 7.85 | 30
 | Total
 |  |  |  |  | Items in this column marked in yellow are balanced, I will speak to you about the errors when I come in.  T