Spreadsheet: 46476d1245329130-counting-cells-of-a-certian-value-example
Sheet: Summary

 |  |  |  |  |  | Deal Name | Month | Originating Country | Product | Segment | ACV (Euros) | TCV ([NAME]) | A/C Margin | Account Type | Month
Total Pricing Requests |  |  |  |  |  | customer 1 | 2009-01-01 00:00:00 | United Kingdom | Link |  |  |  |  | Strategic | 2009-01-01 00:00:00
 |  |  |  |  |  | customer 2 | 2009-01-01 00:00:00 | Germany | Wavelength |  |  |  |  | Strategic | 2009-01-01 00:00:00
 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | Change % |  |  | customer 3 | 2009-01-01 00:00:00 | United Kingdom | IP Access |  |  |  |  | National | 2009-01-01 00:00:00
All Request | 21 | 51 | 1.428571428571429 |  |  | customer 4 | 2009-01-01 00:00:00 | United Kingdom | ColtLink |  |  |  |  | National | 2009-01-01 00:00:00
 |  |  |  |  |  | customer 5 | 2009-01-01 00:00:00 | United Kingdom | Lanlink |  |  |  |  | Strategic | 2009-01-01 00:00:00
Strategic | 6 | 25 | 3.166666666666667 |  |  | customer 6 | 2009-01-01 00:00:00 | Italy | IP Access |  |  |  |  | National | 2009-01-01 00:00:00
National | 15 | 26 | 0.7333333333333333 |  |  | customer 7 | 2009-01-01 00:00:00 | Ireland | Lanlink |  |  |  |  | National | 2009-01-01 00:00:00
 |  |  |  |  |  | customer 8 | 2009-01-01 00:00:00 | Switzerland | Lanlink |  |  |  |  | National | 2009-01-01 00:00:00
 |  |  |  |  |  | customer 9 | 2009-01-01 00:00:00 | Austria | Lanlink |  |  |  |  | National | 2009-01-01 00:00:00
Requests for National A/c's by country |  |  |  |  |  | customer 10 | 2009-01-01 00:00:00 | france | Lanlink |  |  |  |  | National | 2009-01-01 00:00:00
 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | Change % |  |  | customer 11 | 2009-01-01 00:00:00 | The Netherlands | wavelength |  |  |  |  | Strategic | 2009-01-01 00:00:00
Austria |  |  | n/a |  |  | customer 12 | 2009-01-01 00:00:00 | United Kingdom | wavelength |  |  |  |  | Strategic | 2009-01-01 00:00:00
Belgium |  |  | n/a |  |  | customer 13 | 2009-01-01 00:00:00 | United Kingdom | HSS |  |  |  |  | Strategic | 2009-01-01 00:00:00
Denmark |  |  | n/a |  |  | customer 14 | 2009-01-01 00:00:00 | United Kingdom | [NAME] |  |  |  |  | National | 2009-01-01 00:00:00
France |  |  | n/a |  |  | customer 15 | 2009-01-01 00:00:00 | United Kingdom | Lanlink |  |  |  |  | National | 2009-01-01 00:00:00
Germany |  |  | n/a |  |  | customer 16 | 2009-01-01 00:00:00 | Germany | Lanlink |  |  |  |  | National | 2009-01-01 00:00:00
Ireland |  |  | n/a |  |  | customer 17 | 2009-01-01 00:00:00 | United Kingdom | Link |  |  |  |  | National | 2009-01-01 00:00:00
Italy |  |  | n/a |  |  | customer 18 | 2009-01-01 00:00:00 | United Kingdom | Lanlink |  |  |  |  | National | 2009-01-01 00:00:00
The Netherlands |  |  | n/a |  |  | customer 19 | 2009-01-01 00:00:00 | United Kingdom | Link |  |  |  |  | National | 2009-01-01 00:00:00
Portugal |  |  | n/a |  |  | customer 20 | 2009-01-01 00:00:00 | Sweden | wavelength |  |  |  |  | National | 2009-01-01 00:00:00
Spain |  |  | n/a |  |  | customer 21 | 2009-01-01 00:00:00 | United Kingdom | wavelength |  |  |  |  | National | 2009-01-01 00:00:00
Sweden |  |  | n/a |  |  | customer 22 | 2009-02-01 00:00:00 | France | wavelength |  |  |  |  | Strategic | 2009-02-01 00:00:00
Switzerland |  |  | n/a |  |  | customer 23 | 2009-02-01 00:00:00 | United Kingdom | Link |  |  |  |  | National | 2009-02-01 00:00:00
United Kingdom |  |  | n/a |  |  | customer 24 | 2009-02-01 00:00:00 | France | Link |  |  |  |  | National | 2009-02-01 00:00:00
Total | 0 | 0 | n/a |  |  | customer 25 | 2009-02-01 00:00:00 | Belgium | Link |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 26 | 2009-02-01 00:00:00 | France | Link |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 27 | 2009-02-01 00:00:00 | France | wavelength |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 28 | 2009-02-01 00:00:00 | United Kingdom | wavelength |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 29 | 2009-02-01 00:00:00 | Germany | wavelength |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 30 | 2009-02-01 00:00:00 | France | Lanlink |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 31 | 2009-02-01 00:00:00 | United Kingdom | LanLink |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 32 | 2009-02-01 00:00:00 | Sweden | Link |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 33 | 2009-02-01 00:00:00 | United Kingdom | LanLink |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 34 | 2009-02-01 00:00:00 | United Kingdom | LanLink |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 35 | 2009-02-01 00:00:00 | United Kingdom | wavelength |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 36 | 2009-02-01 00:00:00 | Germany | wavelength |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 37 | 2009-02-01 00:00:00 | Switzerland | Link |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 38 | 2009-02-01 00:00:00 | Germany | Link |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 39 | 2009-02-01 00:00:00 | Germany | wavelength |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 40 | 2009-02-01 00:00:00 | France | wavelength |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 41 | 2009-02-01 00:00:00 | France | Link |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 42 | 2009-02-01 00:00:00 | Germany | wavelength |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 43 | 2009-02-01 00:00:00 | France | Colt |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 44 | 2009-02-01 00:00:00 | United Kingdom | IPVPN |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 45 | 2009-02-01 00:00:00 | United Kingdom | LanLink |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 46 | 2009-02-01 00:00:00 | Spain | Link |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 47 | 2009-02-01 00:00:00 | Sweden | Wavelength |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 48 | 2009-02-01 00:00:00 | United Kingdom | MPLS |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 49 | 2009-02-01 00:00:00 | Germany | Wavelength |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 50 | 2009-02-01 00:00:00 | Germany | Wavelength |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 51 | 2009-02-01 00:00:00 | United Kingdom | Lanlink |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 52 | 2009-02-01 00:00:00 | France | Lanlink |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 53 | 2009-02-01 00:00:00 | Germany | wavelength |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 54 | 2009-02-01 00:00:00 | United Kingdom | wavelength |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 55 | 2009-02-01 00:00:00 | Switzerland | Lanlink |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 56 | 2009-02-01 00:00:00 | Ireland | Lanlink |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 57 | 2009-02-01 00:00:00 | United Kingdom | Lanlink |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 58 | 2009-02-01 00:00:00 | Italy | wavelength |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 59 | 2009-02-01 00:00:00 | Italy | wavelength |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 60 | 2009-02-01 00:00:00 | france | Lanlink |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 61 | 2009-02-01 00:00:00 | Sweden | wavelength |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 62 | 2009-02-01 00:00:00 | Germany | wavelength |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 63 | 2009-02-01 00:00:00 | Italy | [NAME] |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 64 | 2009-02-01 00:00:00 | United Kingdom | HSS |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 65 | 2009-02-01 00:00:00 | Sweden | wavelength |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 66 | 2009-02-01 00:00:00 | Sweden | Lanlink |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 67 | 2009-02-01 00:00:00 | Spain | Lanlink |  |  |  |  | Strategic | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 68 | 2009-02-01 00:00:00 | Ireland | Lanlink |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 69 | 2009-02-01 00:00:00 | France | wavelength |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 70 | 2009-02-01 00:00:00 | Sweden | Wavelength |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 71 | 2009-02-01 00:00:00 | Italy | Wavelength |  |  |  |  | National | 2009-02-01 00:00:00
 |  |  |  |  |  | customer 72 | 2009-02-01 00:00:00 | United Kingdom | Lanlink |  |  |  |  | National | 2009-02-01 00:00:00