Spreadsheet: 744447d1629249734-need-help-summing-lines-based-on-id-in-another-column-and-changing-dates-samplea
Sheet: sample

Amount: | 1000
Daily Stop Loss: | 150
Daily Stop Win: | 100
DATE |  |  |  |  |  | ID |  |  |  |  |  |  |  |  |  | T |  | Win.Loss | Count Win.Loss | Count RaceID | Amt | S | P.L | ID P/L | Cum. Day P.L | Cum. P.L | STOP/START/CONTINUE
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE1 |  |  |  |  |  |  |  |  |  | 13.5 |  | Won
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE1 |  |  |  |  |  |  |  |  |  | 7.53 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE2 |  |  |  |  |  |  |  |  |  | 3.13 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE2 |  |  |  |  |  |  |  |  |  | 15.88 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN2 |  |  |  |  |  |  |  |  |  | 4.22 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN2 |  |  |  |  |  |  |  |  |  | 5.3 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE3 |  |  |  |  |  |  |  |  |  | 4.91 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE3 |  |  |  |  |  |  |  |  |  | 10.81 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE4 |  |  |  |  |  |  |  |  |  | 3.45 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE4 |  |  |  |  |  |  |  |  |  | 3.7 |  | Won
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN4 |  |  |  |  |  |  |  |  |  | 5.78 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN4 |  |  |  |  |  |  |  |  |  | 19 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN4 |  |  |  |  |  |  |  |  |  | 9.54 |  | Won
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE5 |  |  |  |  |  |  |  |  |  | 12.59 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE5 |  |  |  |  |  |  |  |  |  | 12.5 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN5 |  |  |  |  |  |  |  |  |  | 2.75 |  | Won
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN5 |  |  |  |  |  |  |  |  |  | 4.78 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE6 |  |  |  |  |  |  |  |  |  | 6.2 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE6 |  |  |  |  |  |  |  |  |  | 8.77 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE6 |  |  |  |  |  |  |  |  |  | 19.5 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN6 |  |  |  |  |  |  |  |  |  | 20.19 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN6 |  |  |  |  |  |  |  |  |  | 4.39 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE7 |  |  |  |  |  |  |  |  |  | 2.59 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE7 |  |  |  |  |  |  |  |  |  | 4.51 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN7 |  |  |  |  |  |  |  |  |  | 4.86 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN7 |  |  |  |  |  |  |  |  |  | 7.81 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN7 |  |  |  |  |  |  |  |  |  | 10.32 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE8 |  |  |  |  |  |  |  |  |  | 4.22 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01FLE8 |  |  |  |  |  |  |  |  |  | 17.5 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN8 |  |  |  |  |  |  |  |  |  | 8.74 |  | Lost
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01KEN8 |  |  |  |  |  |  |  |  |  | 8.79 |  | Lost
2020-01-03 00:00:00 |  |  |  |  |  | 2020-01-03CAN5 |  |  |  |  |  |  |  |  |  | 5.42 |  | Lost
2020-01-03 00:00:00 |  |  |  |  |  | 2020-01-03CAN5 |  |  |  |  |  |  |  |  |  | 3.4 |  | Won
2020-01-03 00:00:00 |  |  |  |  |  | 2020-01-03CAN6 |  |  |  |  |  |  |  |  |  | 4.48 |  | Lost
2020-01-03 00:00:00 |  |  |  |  |  | 2020-01-03CAN6 |  |  |  |  |  |  |  |  |  | 5.55 |  | Won
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU1 |  |  |  |  |  |  |  |  |  | 7.4 |  | Won
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU1 |  |  |  |  |  |  |  |  |  | 6.11 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN1 |  |  |  |  |  |  |  |  |  | 5.8 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN1 |  |  |  |  |  |  |  |  |  | 9.2 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU2 |  |  |  |  |  |  |  |  |  | 2.87 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU2 |  |  |  |  |  |  |  |  |  | 5.7 |  | Won
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU2 |  |  |  |  |  |  |  |  |  | 5 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN2 |  |  |  |  |  |  |  |  |  | 10.04 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN2 |  |  |  |  |  |  |  |  |  | 8 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU3 |  |  |  |  |  |  |  |  |  | 4.1 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU3 |  |  |  |  |  |  |  |  |  | 14 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU3 |  |  |  |  |  |  |  |  |  | 8.93 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN3 |  |  |  |  |  |  |  |  |  | 4.51 |  | Won
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN3 |  |  |  |  |  |  |  |  |  | 6.6 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU5 |  |  |  |  |  |  |  |  |  | 6 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU5 |  |  |  |  |  |  |  |  |  | 17.58 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN5 |  |  |  |  |  |  |  |  |  | 14.33 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN5 |  |  |  |  |  |  |  |  |  | 6.2 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN5 |  |  |  |  |  |  |  |  |  | 20 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN6 |  |  |  |  |  |  |  |  |  | 6.26 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN6 |  |  |  |  |  |  |  |  |  | 4.45 |  | Won
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN6 |  |  |  |  |  |  |  |  |  | 20.01 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN7 |  |  |  |  |  |  |  |  |  | 4.27 |  | Won
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN7 |  |  |  |  |  |  |  |  |  | 5.6 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU8 |  |  |  |  |  |  |  |  |  | 13.27 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU8 |  |  |  |  |  |  |  |  |  | 14.5 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU9 |  |  |  |  |  |  |  |  |  | 5.03 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04CAU9 |  |  |  |  |  |  |  |  |  | 6.2 |  | Lost
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN9 |  |  |  |  |  |  |  |  |  | 5.09 |  | Won
2020-01-04 00:00:00 |  |  |  |  |  | 2020-01-04KEN9 |  |  |  |  |  |  |  |  |  | 4.2 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08WAF3 |  |  |  |  |  |  |  |  |  | 6.8 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08WAF3 |  |  |  |  |  |  |  |  |  | 21 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08WAF4 |  |  |  |  |  |  |  |  |  | 6.22 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08WAF4 |  |  |  |  |  |  |  |  |  | 3.93 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08SLS2 |  |  |  |  |  |  |  |  |  | 13.98 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08SLS2 |  |  |  |  |  |  |  |  |  | 5.7 |  | Won
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08WAF6 |  |  |  |  |  |  |  |  |  | 7 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08WAF6 |  |  |  |  |  |  |  |  |  | 7 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08SLS4 |  |  |  |  |  |  |  |  |  | 18.5 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08SLS4 |  |  |  |  |  |  |  |  |  | 9 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08WAF7 |  |  |  |  |  |  |  |  |  | 4.1 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08WAF7 |  |  |  |  |  |  |  |  |  | 5.5 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08SLS8 |  |  |  |  |  |  |  |  |  | 5.3 |  | Lost
2020-01-08 00:00:00 |  |  |  |  |  | 2020-01-08SLS8 |  |  |  |  |  |  |  |  |  | 18.5 |  | Won
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE2 |  |  |  |  |  |  |  |  |  | 15.74 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE2 |  |  |  |  |  |  |  |  |  | 9.2 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11RAN3 |  |  |  |  |  |  |  |  |  | 3.32 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11RAN3 |  |  |  |  |  |  |  |  |  | 4.9 |  | Won
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE3 |  |  |  |  |  |  |  |  |  | 3.67 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE3 |  |  |  |  |  |  |  |  |  | 7.33 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE4 |  |  |  |  |  |  |  |  |  | 3.6 |  | Won
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE4 |  |  |  |  |  |  |  |  |  | 5.81 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE4 |  |  |  |  |  |  |  |  |  | 15.92 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11RAN5 |  |  |  |  |  |  |  |  |  | 6.81 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11RAN5 |  |  |  |  |  |  |  |  |  | 10.5 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE5 |  |  |  |  |  |  |  |  |  | 11.56 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE5 |  |  |  |  |  |  |  |  |  | 3.6 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11RAN6 |  |  |  |  |  |  |  |  |  | 2.77 |  | Won
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11RAN6 |  |  |  |  |  |  |  |  |  | 6.2 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11RAN6 |  |  |  |  |  |  |  |  |  | 9.6 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE6 |  |  |  |  |  |  |  |  |  | 3.12 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE6 |  |  |  |  |  |  |  |  |  | 8.02 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE7 |  |  |  |  |  |  |  |  |  | 3.95 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE7 |  |  |  |  |  |  |  |  |  | 4.5 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE7 |  |  |  |  |  |  |  |  |  | 16.33 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11RAN8 |  |  |  |  |  |  |  |  |  | 3.4 |  | Won
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11RAN8 |  |  |  |  |  |  |  |  |  | 2.62 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE8 |  |  |  |  |  |  |  |  |  | 3.22 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE8 |  |  |  |  |  |  |  |  |  | 9.2 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE9 |  |  |  |  |  |  |  |  |  | 14 |  | Lost
2020-01-11 00:00:00 |  |  |  |  |  | 2020-01-11FLE9 |  |  |  |  |  |  |  |  |  | 11.53 |  | Lost
2020-01-15 00:00:00 |  |  |  |  |  | 2020-01-15WAF4 |  |  |  |  |  |  |  |  |  | 10 |  | Lost
2020-01-15 00:00:00 |  |  |  |  |  | 2020-01-15WAF4 |  |  |  |  |  |  |  |  |  | 7.2 |  | Lost
2020-01-15 00:00:00 |  |  |  |  |  | 2020-01-15WAF4 |  |  |  |  |  |  |  |  |  | 3.1 |  | Lost
2020-01-15 00:00:00 |  |  |  |  |  | 2020-01-15WAF5 |  |  |  |  |  |  |  |  |  | 2.6 |  | Lost
2020-01-15 00:00:00 |  |  |  |  |  | 2020-01-15WAF5 |  |  |  |  |  |  |  |  |  | 9 |  | Lost
2020-01-15 00:00:00 |  |  |  |  |  | 2020-01-15WAF6 |  |  |  |  |  |  |  |  |  | 3.4 |  | Lost
2020-01-15 00:00:00 |  |  |  |  |  | 2020-01-15WAF6 |  |  |  |  |  |  |  |  |  | 11 |  | Lost
2020-01-15 00:00:00 |  |  |  |  |  | 2020-01-15WAF6 |  |  |  |  |  |  |  |  |  | 7.4 |  | Won
2020-01-15 00:00:00 |  |  |  |  |  | 2020-01-15WAF7 |  |  |  |  |  |  |  |  |  | 4.26 |  | Lost
2020-01-15 00:00:00 |  |  |  |  |  | 2020-01-15WAF7 |  |  |  |  |  |  |  |  |  | 4.96 |  | Lost
2020-01-15 00:00:00 |  |  |  |  |  | 2020-01-15WAF7 |  |  |  |  |  |  |  |  |  | 7.4 |  | Lost
2020-01-17 00:00:00 |  |  |  |  |  | 2020-01-17CAN5 |  |  |  |  |  |  |  |  |  | 5 |  | Lost
2020-01-17 00:00:00 |  |  |  |  |  | 2020-01-17CAN5 |  |  |  |  |  |  |  |  |  | 11.12 |  | Lost
2020-01-17 00:00:00 |  |  |  |  |  | 2020-01-17CAN5 |  |  |  |  |  |  |  |  |  | 3.7 |  | Lost
2020-01-17 00:00:00 |  |  |  |  |  | 2020-01-17CAN6 |  |  |  |  |  |  |  |  |  | 6.22 |  | Lost
2020-01-17 00:00:00 |  |  |  |  |  | 2020-01-17CAN6 |  |  |  |  |  |  |  |  |  | 6.15 |  | Lost
2020-01-17 00:00:00 |  |  |  |  |  | 2020-01-17CAN7 |  |  |  |  |  |  |  |  |  | 7.96 |  | Lost
2020-01-17 00:00:00 |  |  |  |  |  | 2020-01-17CAN7 |  |  |  |  |  |  |  |  |  | 11.5 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18ROS2 |  |  |  |  |  |  |  |  |  | 4.4 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18ROS2 |  |  |  |  |  |  |  |  |  | 15 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18ROS2 |  |  |  |  |  |  |  |  |  | 7 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18ROS4 |  |  |  |  |  |  |  |  |  | 3.2 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18ROS4 |  |  |  |  |  |  |  |  |  | 7.97 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18FLE1 |  |  |  |  |  |  |  |  |  | 5.11 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18FLE1 |  |  |  |  |  |  |  |  |  | 5.87 |  | Won
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18FLE1 |  |  |  |  |  |  |  |  |  | 6.41 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18FLE2 |  |  |  |  |  |  |  |  |  | 2.92 |  | Won
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18FLE2 |  |  |  |  |  |  |  |  |  | 5.5 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18FLE2 |  |  |  |  |  |  |  |  |  | 4.8 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18ROS6 |  |  |  |  |  |  |  |  |  | 9.4 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18ROS6 |  |  |  |  |  |  |  |  |  | 8.2 |  | Won
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18FLE3 |  |  |  |  |  |  |  |  |  | 3.7 |  | Won
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18FLE3 |  |  |  |  |  |  |  |  |  | 10.5 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18FLE3 |  |  |  |  |  |  |  |  |  | 3.8 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18FLE4 |  |  |  |  |  |  |  |  |  | 4.1 |  | Lost
2020-01-18 00:00:00 |  |  |  |  |  | 2020-01-18FLE4 |  |  |  |  |  |  |  |  |  | 11 |  | Lost