Spreadsheet: 70316d1271103886-sumif-within-a-sumif-test-worksheet-a
Sheet: Q4 FY10

Customer Number: | Close Date | Amount (converted, €) | Probability (%) | Expected Revenue (converted) | Date Code: (Do Not Delete) | Account: Country (Used for Reporting)
1 | 2010-07-12 00:00:00 | 61476.39 | 45 | 27664.38 | 72010 | Ecuador
2 | 2010-07-14 00:00:00 | 33249.6 | 60 | 19949.76 | 72010 | Mexico
3 | 2010-07-16 00:00:00 | 176859.59 | 60 | 106115.75 | 72010 | Mexico
4 | 2010-07-16 00:00:00 | 35371.92 | 40 | 14148.77 | 72010 | Mexico
5 | 2010-07-30 00:00:00 | 7344.94 | 15 | 1101.74 | 72010 | Brazil
6 | 2010-07-30 00:00:00 | 183623.55 | 0 | 0 | 72010 | Brazil
7 | 2010-07-30 00:00:00 | 734.49 | 30 | 220.35 | 72010 | Brazil
8 | 2010-07-30 00:00:00 |  | 20 |  | 72010 | Brazil
9 | 2010-07-30 00:00:00 | 121742.41 | 40 | 48696.96 | 72010 | Brazil
10 | 2010-07-30 00:00:00 | 3672.47 | 25 | 918.12 | 72010 | Brazil
11 | 2010-07-30 00:00:00 | 3672.47 | 20 | 734.49 | 72010 | Brazil
12 | 2010-07-30 00:00:00 | 867804.88 | 60 | 520682.93 | 72010 | Brazil
13 | 2010-07-30 00:00:00 | 143226.37 | 50 | 71613.18 | 72010 | Brazil
14 | 2010-07-30 00:00:00 | 20565.84 | 30 | 6169.75 | 72010 | Brazil
15 | 2010-07-30 00:00:00 | 7344.94 | 60 | 4406.97 | 72010 | Brazil
16 | 2010-07-30 00:00:00 | 13955.39 | 30 | 4186.62 | 72010 | Brazil
17 | 2010-07-30 00:00:00 | 4112.87 | 30 | 1233.86 | 72010 | Brazil
18 | 2010-07-30 00:00:00 | 22034.83 | 0 | 0 | 72010 | Brazil
19 | 2010-07-30 00:00:00 | 9904.14 | 40 | 3961.65 | 72010 | Brazil
20 | 2010-07-31 00:00:00 | 183623.55 | 15 | 27543.53 | 72010 | Brazil
21 | 2010-07-31 00:00:00 | 9181.18 | 15 | 1377.18 | 72010 | Brazil
22 | 2010-07-31 00:00:00 | 367247.09 | 30 | 110174.13 | 72010 | Brazil
23 | 2010-07-31 00:00:00 | 359902.15 | 30 | 107970.65 | 72010 | Brazil
24 | 2010-07-31 00:00:00 | 9181.18 | 45 | 4131.53 | 72010 | Brazil
25 | 2010-07-31 00:00:00 | 18362.35 | 20 | 3672.47 | 72010 | Brazil
26 | 2010-07-31 00:00:00 | 229529.43 | 50 | 114764.72 | 72010 | Brazil
27 | 2010-07-31 00:00:00 | 267047.4 | 30 | 80114.22 | 72010 | Brazil
28 | 2010-07-31 00:00:00 | 165261.19 | 35 | 57841.42 | 72010 | Brazil
29 | 2010-07-31 00:00:00 | 165261.19 | 35 | 57841.42 | 72010 | Brazil
30 | 2010-07-31 00:00:00 | 36724.71 | 30 | 11017.41 | 72010 | Brazil
31 | 2010-07-31 00:00:00 | 146898.84 | 0 | 0 | 72010 | Brazil
32 | 2010-07-31 00:00:00 | 110174.13 | 0 | 0 | 72010 | Brazil
33 | 2010-08-16 00:00:00 | 12733.89 | 40 | 5093.56 | 82010 | Mexico
34 | 2010-08-31 00:00:00 | 73449.42 | 15 | 11017.41 | 82010 | Brazil
35 | 2010-08-31 00:00:00 | 22034.83 | 15 | 3305.22 | 82010 | Brazil
36 | 2010-08-31 00:00:00 | 646354.88 | 20 | 129270.98 | 82010 | Brazil
37 | 2010-08-31 00:00:00 | 403971.8 | 30 | 121191.54 | 82010 | Brazil
38 | 2010-08-31 00:00:00 | 73449.42 | 45 | 33052.24 | 82010 | Brazil
39 | 2010-08-31 00:00:00 | 18362.35 | 40 | 7344.94 | 82010 | Brazil
40 | 2010-08-31 00:00:00 | 9181.18 | 45 | 4131.53 | 82010 | Brazil
41 | 2010-08-31 00:00:00 | 47742.12 | 30 | 14322.64 | 82010 | Brazil
42 | 2010-08-31 00:00:00 | 22034.83 | 50 | 11017.41 | 82010 | Brazil
43 | 2010-08-31 00:00:00 | 146898.84 | 0 | 0 | 82010 | Brazil
44 | 2010-08-31 00:00:00 | 23136.57 | 0 | 0 | 82010 | Brazil
45 | 2010-08-31 00:00:00 | 56923.3 | 50 | 28461.65 | 82010 | Brazil
46 | 2010-08-31 00:00:00 | 55087.06 | 30 | 16526.12 | 82010 | Brazil
47 | 2010-08-31 00:00:00 | 4825.78 | 40 | 1930.31 | 82010 | Mexico
48 | 2010-09-03 00:00:00 | 14148.77 | 15 | 2122.32 | 92010 | Mexico
49 | 2010-09-17 00:00:00 | 49520.68 | 15 | 7428.1 | 92010 | Argentina
50 | 2010-09-20 00:00:00 | 74988.46 | 75 | 56241.35 | 92010 | Mexico
51 | 2010-09-20 00:00:00 | 62962.01 | 40 | 25184.81 | 92010 | Mexico
52 | 2010-09-30 00:00:00 | 44069.65 | 15 | 6610.45 | 92010 | Brazil
53 | 2010-09-30 00:00:00 | 36724.71 | 15 | 5508.71 | 92010 | Brazil
54 | 2010-09-30 00:00:00 | 36724.71 | 15 | 5508.71 | 92010 | Brazil
55 | 2010-09-30 00:00:00 | 7344.94 | 15 | 1101.74 | 92010 | Brazil
56 | 2010-09-30 00:00:00 | 7344.94 | 15 | 1101.74 | 92010 | Brazil
57 | 2010-09-30 00:00:00 | 6610.45 | 15 | 991.57 | 92010 | Brazil
58 | 2010-09-30 00:00:00 |  | 15 |  | 92010 | Brazil
59 | 2010-09-30 00:00:00 | 624320.06 | 30 | 187296.02 | 92010 | Brazil
60 | 2010-09-30 00:00:00 | 587595.35 | 10 | 58759.53 | 92010 | Brazil
61 | 2010-09-30 00:00:00 | 7344.94 | 30 | 2203.48 | 92010 | Brazil
62 | 2010-09-30 00:00:00 | 450795.81 | 45 | 202858.11 | 92010 | Brazil
63 | 2010-09-30 00:00:00 | 440696.51 | 45 | 198313.43 | 92010 | Brazil
64 | 2010-09-30 00:00:00 | 330522.38 | 20 | 66104.48 | 92010 | Brazil
65 | 2010-09-30 00:00:00 | 117519.07 | 40 | 47007.63 | 92010 | Brazil
66 | 2010-09-30 00:00:00 | 66104.48 | 45 | 29747.01 | 92010 | Brazil
67 | 2010-09-30 00:00:00 | 36724.71 | 30 | 11017.41 | 92010 | Brazil
68 | 2010-09-30 00:00:00 | 37496.86 | 0 | 0 | 92010 | Brazil
69 | 2010-09-30 00:00:00 | 550870.64 | 60 | 330522.38 | 92010 | Brazil
70 | 2010-09-30 00:00:00 | 440696.51 | 60 | 264417.91 | 92010 | Brazil
71 | 2010-09-30 00:00:00 | 220348.26 | 60 | 132208.95 | 92010 | Brazil
72 | 2010-09-30 00:00:00 | 110174.13 | 60 | 66104.48 | 92010 | Brazil
73 | 2010-09-30 00:00:00 | 70743.83 | 40 | 28297.53 | 92010 | Mexico
74 | 2010-09-30 00:00:00 | 18362.35 | 20 | 3672.47 | 92010 | Brazil
75 | 2010-09-30 00:00:00 | 7344.94 | 50 | 3672.47 | 92010 | Brazil
76 | 2010-09-30 00:00:00 | 146898.84 | 0 | 0 | 92010 | Brazil
77 | 2010-09-30 00:00:00 | 51414.59 | 60 | 30848.76 | 92010 | Brazil
78 | 2010-09-30 00:00:00 | 36724.71 | 75 | 27543.53 | 92010 | Brazil
79 | 2010-09-30 00:00:00 | 40323.99 | 60 | 24194.39 | 92010 | Mexico
80 | 2010-09-30 00:00:00 | 24760.34 | 60 | 14856.21 | 92010 | Mexico
81 | 2010-09-30 00:00:00 | 21223.15 | 60 | 12733.89 | 92010 | Mexico
82 | 2010-09-30 00:00:00 | 11017.41 | 90 | 9915.67 | 92010 | Brazil
83 | 2010-09-30 00:00:00 | 3672.47 | 90 | 3305.22 | 92010 | Brazil
Brazil |  | 36004641803343.01 |  | Sumproduct
Brazil |  | 13297316.48 |  | Sum