Spreadsheet: 136430d1326641940-excel-2008-how-to-count-and-or-sum-consecutive-values-on-a-range-with-blank-data-in-the-middle-gtichauer_sumranges
Sheet: Consecutive

 |  |  |  |  |  |  |  |  |  | Helper Cols
 |  |  |  | 1 |  |  |  |  |  | Is there a trade | Consec Losses |  |  | Consec Wins
1 | 2007-01-01 00:00:00 | 100 | W |  |  |  |  | 2007-01-01 00:00:00 | 100 | 1 |  |  |  | W | 1 | 100 |  | W | 1
2 | 2007-01-02 00:00:00 | 100 | W |  |  |  |  | 2007-01-02 00:00:00 | 100 | 1 |  |  |  | W | 2 | 200 |  | W | 2
3 | 2007-01-03 00:00:00 | 100 | W |  |  |  |  | 2007-01-03 00:00:00 | 100 | 1 |  |  |  | W | 3 | 300 |  | W | 3
4 | 2007-01-04 00:00:00 |  | 0 |  |  |  |  | 2007-01-04 00:00:00 |  |  |  |  |  |  |  |  |  | W | 3
5 | 2007-01-05 00:00:00 |  | 0 |  |  |  |  | 2007-01-05 00:00:00 |  |  |  |  |  |  |  |  |  | W | 3
6 | 2007-01-06 00:00:00 |  | 0 |  |  |  |  | 2007-01-06 00:00:00 |  |  |  |  |  |  |  |  |  | W | 3
7 | 2007-01-07 00:00:00 |  | 0 |  |  |  |  | 2007-01-07 00:00:00 |  |  |  |  |  |  |  |  |  | W | 3
1 | 2007-01-08 00:00:00 |  | 0 |  |  |  |  | 2007-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | W | 3
2 | 2007-01-09 00:00:00 |  | 0 |  |  |  |  | 2007-01-09 00:00:00 |  |  |  |  |  |  |  |  |  | W | 3
3 | 2007-01-10 00:00:00 | 100 | W |  |  |  |  | 2007-01-10 00:00:00 | 100 | 1 |  |  |  | W | 1 | 100 |  | W | 4
4 | 2007-01-11 00:00:00 | 100 | W |  |  |  |  | 2007-01-11 00:00:00 | 100 | 1 |  |  |  | W | 2 | 200 |  | W | 5
5 | 2007-01-12 00:00:00 | 100 | W | 14 | 600 | 0 |  | 2007-01-12 00:00:00 | 100 | 1 |  |  |  | W | 3 | 300 |  | W | 6
6 | 2007-01-13 00:00:00 | -50 | L |  |  |  |  | 2007-01-13 00:00:00 | -50 | 1 | L | 1 | -50 |  |  |  |  | L | 1
7 | 2007-01-14 00:00:00 | -50 | L |  |  |  |  | 2007-01-14 00:00:00 | -50 | 1 | L | 2 | -100 |  |  |  |  | L | 2
1 | 2007-01-15 00:00:00 | -50 | L |  |  |  |  | 2007-01-15 00:00:00 | -50 | 1 | L | 3 | -150 |  |  |  |  | L | 3
2 | 2007-01-16 00:00:00 | -50 | L |  |  |  |  | 2007-01-16 00:00:00 | -50 | 1 | L | 4 | -200 |  |  |  |  | L | 4
3 | 2007-01-17 00:00:00 | -50 | L |  |  |  |  | 2007-01-17 00:00:00 | -50 | 1 | L | 5 | -250 |  |  |  |  | L | 5
4 | 2007-01-18 00:00:00 |  | 0 |  |  |  |  | 2007-01-18 00:00:00 |  |  |  |  |  |  |  |  |  | L | 5
5 | 2007-01-19 00:00:00 |  | 0 |  |  |  |  | 2007-01-19 00:00:00 |  |  |  |  |  |  |  |  |  | L | 5
6 | 2007-01-20 00:00:00 |  | 0 |  |  |  |  | 2007-01-20 00:00:00 |  |  |  |  |  |  |  |  |  | L | 5
7 | 2007-01-21 00:00:00 | -50 | L | 23 | -300 | 0 |  | 2007-01-21 00:00:00 | -50 | 1 | L | 1 | -50 |  |  |  |  | L | 6
1 | 2007-01-22 00:00:00 | 200 | W |  |  |  |  | 2007-01-22 00:00:00 | 200 | 1 |  |  |  | W | 1 | 200 |  | W | 1
2 | 2007-01-23 00:00:00 | 200 | W |  |  |  |  | 2007-01-23 00:00:00 | 200 | 1 |  |  |  | W | 2 | 400 |  | W | 2
3 | 2007-01-24 00:00:00 | 200 | W | 26 | 600 | 0 |  | 2007-01-24 00:00:00 | 200 | 1 |  |  |  | W | 3 | 600 |  | W | 3
4 | 2007-01-25 00:00:00 | -100 | L |  |  |  |  | 2007-01-25 00:00:00 | -100 | 1 | L | 1 | -100 |  |  |  |  | L | 1
5 | 2007-01-26 00:00:00 | -100 | L |  |  |  |  | 2007-01-26 00:00:00 | -100 | 1 | L | 2 | -200 |  |  |  |  | L | 2
6 | 2007-01-27 00:00:00 | -100 | L | 29 | -300 | 0 |  | 2007-01-27 00:00:00 | -100 | 1 | L | 3 | -300 |  |  |  |  | L | 3