Spreadsheet: 220685d1363232495-summing-and-ranking-rank-example-bvj-
Sheet: Sheet1

Date | Client Name | REGION | USD |  |  |  |  |  | REGION | (All)
2012-08-01 00:00:00 | ABC | EUROPE | 77.91 |  |  |  |  |  | Rank:
2012-08-01 00:00:00 | ABC | EUROPE | 11.62 |  |  |  |  |  | Sum of USD | Client
2012-08-01 00:00:00 | ABC | EUROPE | 63.77 |  |  |  |  |  | Dates | ABC | DEF | GHI | JKL | MNO | PQR | STU | VWXZY
2012-08-01 00:00:00 | DEF | EUROPE | 21.33 |  |  |  |  |  | 2012-08-01 00:00:00 | 153.3 | 140.27 | 126.63 | 126.67 | 173.27 | 195.5 | 184.05 | 252.66
2012-08-01 00:00:00 | DEF | EUROPE | 73.35 |  |  |  |  |  | 2012-09-01 00:00:00 | 141.39 | 49.47 | 159.66 | 216.73 | 227.91 | 269.1 | 108.23 | 126.67
2012-08-01 00:00:00 | DEF | EUROPE | 43.66 |  |  |  |  |  | 2012-10-01 00:00:00 | 138.29 | 315.77 | 73.85 | 229.43 | 154.1 | 106.78 | 139.94 | 373.94
2012-08-01 00:00:00 | DEF | EUROPE | 1.93 |  |  |  |  |  | Grand Total | 432.98 | 505.51 | 360.14 | 572.83 | 555.28 | 571.38 | 432.22 | 753.27
2012-08-01 00:00:00 | GHI | ASIA | 50.18
2012-08-01 00:00:00 | GHI | ASIA | 71.56
2012-08-01 00:00:00 | GHI | ASIA | 4.89
2012-08-01 00:00:00 | JKL | ASIA | 17.82
2012-08-01 00:00:00 | JKL | ASIA | 96.34
2012-08-01 00:00:00 | JKL | ASIA | 12.51
2012-08-01 00:00:00 | MNO | ASIA | 15.11
2012-08-01 00:00:00 | MNO | ASIA | 31.72
2012-08-01 00:00:00 | MNO | ASIA | 35.37
2012-08-01 00:00:00 | MNO | ASIA | 91.07
2012-08-01 00:00:00 | PQR | EUROPE | 52.26
2012-08-01 00:00:00 | PQR | EUROPE | 11.28
2012-08-01 00:00:00 | PQR | EUROPE | 83.51
2012-08-01 00:00:00 | PQR | EUROPE | 48.45
2012-08-01 00:00:00 | STU | EUROPE | 70.99
2012-08-01 00:00:00 | STU | EUROPE | 72.22
2012-08-01 00:00:00 | STU | EUROPE | 40.84
2012-08-01 00:00:00 | VWXZY | ASIA | 17.81
2012-08-01 00:00:00 | VWXZY | ASIA | 63.14
2012-08-01 00:00:00 | VWXZY | ASIA | 82.31
2012-08-01 00:00:00 | VWXZY | ASIA | 85.85
2012-08-01 00:00:00 | VWXZY | ASIA | 3.55
2012-09-01 00:00:00 | ABC | EUROPE | 14.78
2012-09-01 00:00:00 | ABC | EUROPE | 84.05
2012-09-01 00:00:00 | ABC | EUROPE | 42.56
2012-09-01 00:00:00 | DEF | EUROPE | 6.4
2012-09-01 00:00:00 | DEF | EUROPE | 11.56
2012-09-01 00:00:00 | DEF | EUROPE | 8.68
2012-09-01 00:00:00 | DEF | EUROPE | 22.83
2012-09-01 00:00:00 | GHI | ASIA | 48.34
2012-09-01 00:00:00 | GHI | ASIA | 16.52
2012-09-01 00:00:00 | GHI | ASIA | 94.8
2012-09-01 00:00:00 | JKL | ASIA | 92.94
2012-09-01 00:00:00 | JKL | ASIA | 35.59
2012-09-01 00:00:00 | JKL | ASIA | 88.2
2012-09-01 00:00:00 | MNO | ASIA | 86.07
2012-09-01 00:00:00 | MNO | ASIA | 44.71
2012-09-01 00:00:00 | MNO | ASIA | 5.59
2012-09-01 00:00:00 | MNO | ASIA | 91.54
2012-09-01 00:00:00 | PQR | EUROPE | 95.62
2012-09-01 00:00:00 | PQR | EUROPE | 55.34
2012-09-01 00:00:00 | PQR | EUROPE | 42.12
2012-09-01 00:00:00 | PQR | EUROPE | 76.02
2012-09-01 00:00:00 | STU | EUROPE | 52.21
2012-09-01 00:00:00 | STU | EUROPE | 13.42
2012-09-01 00:00:00 | STU | EUROPE | 42.6
2012-09-01 00:00:00 | VWXZY | ASIA | 30.14
2012-09-01 00:00:00 | VWXZY | ASIA | 14.09
2012-09-01 00:00:00 | VWXZY | ASIA | 0.36
2012-09-01 00:00:00 | VWXZY | ASIA | 57.62
2012-09-01 00:00:00 | VWXZY | ASIA | 24.46
2012-10-01 00:00:00 | ABC | EUROPE | 56.89
2012-10-01 00:00:00 | ABC | EUROPE | 56.69
2012-10-01 00:00:00 | ABC | EUROPE | 24.71
2012-10-01 00:00:00 | DEF | EUROPE | 89.9
2012-10-01 00:00:00 | DEF | EUROPE | 94.36
2012-10-01 00:00:00 | DEF | EUROPE | 35.66
2012-10-01 00:00:00 | DEF | EUROPE | 95.85
2012-10-01 00:00:00 | GHI | ASIA | 11.75
2012-10-01 00:00:00 | GHI | ASIA | 22.68
2012-10-01 00:00:00 | GHI | ASIA | 39.42
2012-10-01 00:00:00 | JKL | ASIA | 99.22
2012-10-01 00:00:00 | JKL | ASIA | 86.15
2012-10-01 00:00:00 | JKL | ASIA | 44.06
2012-10-01 00:00:00 | MNO | ASIA | 39.58
2012-10-01 00:00:00 | MNO | ASIA | 47.41
2012-10-01 00:00:00 | MNO | ASIA | 64.89
2012-10-01 00:00:00 | MNO | ASIA | 2.22
2012-10-01 00:00:00 | PQR | EUROPE | 10.02
2012-10-01 00:00:00 | PQR | EUROPE | 3.37
2012-10-01 00:00:00 | PQR | EUROPE | 9
2012-10-01 00:00:00 | PQR | EUROPE | 84.39
2012-10-01 00:00:00 | STU | EUROPE | 17.03
2012-10-01 00:00:00 | STU | EUROPE | 79.39
2012-10-01 00:00:00 | STU | EUROPE | 43.52
2012-10-01 00:00:00 | VWXZY | ASIA | 80.92
2012-10-01 00:00:00 | VWXZY | ASIA | 72.37
2012-10-01 00:00:00 | VWXZY | ASIA | 96.51
2012-10-01 00:00:00 | VWXZY | ASIA | 79.71
2012-10-01 00:00:00 | VWXZY | ASIA | 44.43