Spreadsheet: 673688d1587490123-any-alternatives-to-sumifs-and-countifs-to-speed-up-a-workbooks-calc-time-sumifs
Sheet: ALL

 |  |  |  |  | 2 | 2016-09-30 11:24:00 | 00:00:00 |  | Deposit | 0 |  |  |  |  |  | 0 | 0 | 500 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 1 |  | 1 | 200 | 2 | 2016-09-30 12:03:00 | 00:00:00 |  | Deposit | 0.01 |  |  |  |  |  | 0 | 0 | 100 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 1 |  | 1 |  | 2 | 2016-10-03 00:30:00 | 2016-10-03 16:00:00 |  | Sell | 0.01 |  |  |  |  |  | 0 | -1.2 | -0.16 |  |  |  |  |  |  | 10.8 | 0.85 | 8.9 | 0.89 | -7.6 | -0.76
 | 1 |  | 1 | 200 | 2 | 2016-10-03 00:50:00 | 2016-10-03 20:00:00 |  | Sell | 0.01 |  |  |  |  |  | 0 | -23.5 | -2.44 |  |  |  |  |  |  | 34.4 | 3.41 | 7.8 | 0.78 | -26.6 | -2.66
 | 1 |  | 1 | 200 | 2 | 2016-10-03 23:37:00 | 2016-10-04 09:40:00 |  | Buy | 0.01 |  |  |  |  |  | -0.01 | -23.3 | -1.73 |  |  |  |  |  |  | 33.1 | 33.11 | 0 | 0 | -33.1 | -2.317
 | 1 |  | 1 | 500 | 2 | 2016-10-04 17:00:00 | 00:00:00 |  | Withdrawal | 0.01 |  |  |  |  |  | 0 | 0 | -95 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 0 |  | 1 | 200 | 2 | 2016-10-04 18:01:00 | 2016-10-05 02:20:00 |  | Sell | 0.02 |  |  |  |  |  | -0.01 | -52.6 | -7.62 |  |  |  |  |  |  | 59.5 | 59.52 | 0 | 0 | -59.5 | -8.33
 | 1 |  | 1 | 500 | 2 | 2016-10-04 19:49:00 | 2016-10-05 04:59:00 |  | Sell | 0.01 |  |  |  |  |  | 0 | -76.8 | -5.54 |  |  |  |  |  |  | 76.8 | 76.92 | 0 | 0 | -76.8 | -5.376
 | 1 |  | 1 |  | 2 | 2016-10-04 20:11:00 | 2016-10-04 20:47:00 |  | Buy | 0.01 |  |  |  |  |  | 0 | 9.3 | 0.69 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | 1 |  | 1 |  | 2 | 2016-10-04 23:00:00 | 2016-10-05 02:20:00 |  | Sell | 0.02 |  |  |  |  |  | -0.01 | -35.4 | -5.15 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 2 | 2016-10-04 23:01:00 | 2016-10-05 04:59:00 |  | Sell | 0.01 |  |  |  |  |  | 0 | -63.5 | -4.59 |  |  |  |  |  |  | 63.5 | 63.69 | 0 | 0 | -63.5 | -4.445
 |  |  |  |  | 2 | 2016-10-04 23:03:00 | 00:00:00 |  | Deposit | 0.01 |  |  |  |  |  | 0 | 0 | 500 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 2 | 2016-10-05 18:42:00 | 2016-10-06 00:28:00 |  | Sell | 0.04 |  |  |  |  |  | 0.07 | 1.5 | 0.4 |  |  |  |  |  |  | 12.1 | 4.84 | 2.5 | 0.725 | -12.1 | -3.50899999999999
 |  |  |  |  | 2 | 2016-10-10 18:18:00 | 2016-10-10 22:35:00 |  | Sell | 0.04 |  |  |  |  |  | 0 | 12 | 3.33 |  |  |  |  |  |  | 8.6 | 0.05 | 20.6 | 5.974 | 0 | 0
 |  |  |  |  | 2 | 2016-10-10 19:17:00 | 2016-10-11 02:47:00 |  | Sell | 0.02 |  |  |  |  |  | -0.07 | 10.7 | 1.51 |  |  |  |  |  |  | 13.7 | 0 | 24.4 | 3.65999999999999 | -0.1 | -0.015
 |  |  |  |  | 2 | 2016-10-12 20:47:00 | 2016-10-13 00:23:00 |  | Buy | 0.02 |  |  |  |  |  | -0.05 | 13.7 | 1.84 |  |  |  |  |  |  | 12 | 0.23 | 24 | 3.36 | -5.5 | -0.77
 |  |  |  |  | 2 | 2016-10-14 01:00:00 | 2016-10-14 12:00:00 |  | Sell | 0.02 |  |  |  |  |  | 0 | 28.8 | 5.69 |  |  |  |  |  |  | 13.1 | 0.04 | 41.9 | 8.38 | -1.7 | -0.34
 |  |  |  |  | 2 | 2016-10-17 00:30:00 | 2016-10-17 12:10:00 |  | Buy | 0.02 |  |  |  |  |  | 0 | 24.2 | 4.77 |  |  |  |  |  |  | 13.9 | 0.21 | 24.2 | 4.84 | -5.1 | -1.02
 |  |  |  |  | 2 | 2016-10-17 03:00:00 | 2016-10-17 12:12:00 |  | Sell | 0.02 |  |  |  |  |  | 0 | 25.4 | 5.08 |  |  |  |  |  |  | 10.1 | 0.04 | 25.4 | 5.08 | 0 | 0