Spreadsheet: 154359d1336399305-using-countif-to-number-of-in-certain-date-ranges-0seescotland-client-list-oct-2012
Sheet: Sheet1

SeeScotland - Client List |  |  |  |  |  |  | 1990 | 1980 | <<<<< | <<<<<<<<<<<< | Type your dates here
 |  |  |  |  |  |  | end date | start date
Company Name | Surname | Forename | Status | DOB | Address 1 | Address 2 | Town | Postcode | Client Code | helper column.You can hide this
Walters Enterprises | [NAME] | [NAME] | Mr |  | Garden Place |  | Oldburgh | DY14 6BL | 1 | 1900 | 3
SFEI | Blister | [NAME] | Mr |  | Stiling Avenue |  | Stirling | ST8 LI9 | 1 | 1900 | 3
[NAME] | Blythe | [NAME] | Miss |  | Barnstaple Road |  | [NAME] | LP9 3DR | 1 | 1900
Music Box | Bird | [NAME] | Mrs |  | Bankhead Avenue | Sighthill | Edinburgh | EH11 4DE | 1 | 1900
Deli Polonia | Bonaparte | Napoleon | Mr |  | 123 Princes Street |  | Edinburgh | EH1 1HE | 1 | 1900
Club 60-61 | [NAME] | Walter | Mr |  | Rue de Arbre |  | Edinburgh | EH3 1HE | 1 | 1900
 | Paris | Hilton | Miss |  | Bar-L |  | [NAME] | [NAME] | 2 | 1900
Farmacutical Company | [NAME] | [NAME] | Miss |  | The Drying Hut |  | [NAME] | GR8 7TE | 1 | 1900 | your result here
 | [NAME] | Horatio | Mr | 1950-04-01 00:00:00 | 98 Iona Street | Leith | Edinburgh | EH6 6HE | 2 | 1950
[NAME] | Carberry | [NAME] | Mrs |  | Garvock Hill |  | Strathfermline | DY12 5TK | 1 | 1900
Paton and Sons | Paton | [NAME] | Mrs |  | 24 Low Road | Parkneuk | Strathfermline | DY11 4BX | 1 | 1900
 | [NAME] | Stephen | Mr | 1972-11-12 00:00:00 | 8 Gorno Grove |  | Dunmiglo | DY14 7SE | 2 | 1972
 | Ewing | [NAME] | Ms | 1966-11-22 00:00:00 | 5 Castle Street |  | Eastsea | DY10 3SH | 2 | 1966
 | Drysdale | [NAME] | Mr | 1972-11-15 00:00:00 | 59 Grangemouth Road |  | West Central | QH51 0PT | 2 | 1972
 | [NAME] | [NAME] | Mrs | 1953-03-02 00:00:00 | 102 Stenhouse Street |  | Beathloch | DY4 9DA | 2 | 1953
 | [NAME] | [NAME] | Mr | 1970-12-01 00:00:00 | 5 Howdenhall Loan |  | Capitalburgh | QH16 6UY | 2 | 1970
Fyfe Nurseries | Fyfe | Amanda | Miss |  | 6 Horsemarket Street |  | Falkhaven | DY7 7BG | 1 | 1900
 | Asher | [NAME] | Mr | 1958-09-30 00:00:00 | 56 Hill Grove | Comrie | Strathfermline | DY12 9XF | 2 | 1958
Pet Supplies plc | McFarlane | Elaine | Mrs | 1954-07-01 00:00:00 | 5 [NAME] |  | [NAME] | DY11 2LB | 1 | 1954
 | Grubb | [NAME] | Mr | 1945-06-14 00:00:00 | 24 Gardner Crescent | Whitburn | West Central | QH32 3RT | 2 | 1945
 | [NAME] | [NAME] | Mr | 1956-05-10 00:00:00 | 1 Calmans Wynd |  | Pittenhaven | DY12 2NS | 2 | 1956
Copying Solutions | Thompson | [NAME] | Mr |  | 45a East Main Street | Uphall | West Central | QH52 5DZ | 1 | 1900
Desings Ltd | Petrie | [NAME] | Miss |  | 5 Pestfield Drive | Crossgates | Strathfermline | DY11 8BY | 1 | 1900
Twilight Home Group | Rhodes | Frances | Mrs |  | 70 Ryehill Avenue |  | Capitalburgh | [NAME] | 1 | 1900
Marketing Solutions | Cooper | George | Mr |  | Pinewood Place | Junefield | Forthside | QH22 5JA | 1 | 1900
 | Clarke | [NAME] | Mr | 1943-01-28 00:00:00 | 8 Inchgarvie Crescent |  | Inverforth | DY11 4HL | 2 | 1943
 | [NAME] | Iona | Miss | 1979-06-08 00:00:00 | 14 Bishopgate |  | Howe | DY15 4BB | 2 | 1979
 | Motion | Pauline | Ms | 1974-06-16 00:00:00 | 99 Glen Road |  | West Central | QH48 3NG | 2 | 1974
 | Barley | Christine | Mrs | 1954-06-11 00:00:00 | 45 Lovedale Crescent | Southburn | Forthside | QH14 7DP | 2 | 1954
Post Office Supplies | McNab | [NAME] | Mr |  | 5 Market Street | Coldstream | Berwick | GD12 4BU | 1 | 1900
 | Pinder | [NAME] | Miss | 1979-04-30 00:00:00 | 102 Craigmount Brae |  | Capitalburgh | QH12 8XD | 2 | 1979
Concorde Music Shops | Lennie | [NAME] | Mr |  | 56 Westburn Grove |  | Capitalburgh | QH14 2KY | 1 | 1900
 | Wood | [NAME] | Miss | 1977-12-12 00:00:00 | 22 Stirling Road |  | Glenblane | PK15 9EP | 2 | 1977
 | [NAME] | [NAME] | Ms | 1979-02-03 00:00:00 | 4 Kingseat Road | Halbeath | Strathfermline | DY12 0UB | 2 | 1979
[NAME] | [NAME] | [NAME] | Mrs |  | 8 Albany Crescent |  | Falkhaven | DY7 7EH | 1 | 1900
Gillespie Marketing | Gillespie | Ian | Mr |  | 38 Drove Road | Armadale | West Central | QH48 3NP | 1 | 1900
Simpson Estates | Simpson | Kirsten | Ms |  | 27 Lovedale Avenue |  | Forthside | QH14 7DT | 1 | 1900
 | Smithard | [NAME] | Mr | 1952-03-23 00:00:00 | 67 Raith Avenue |  | Beathloch | DY4 8PB | 2 | 1952
 | [NAME] | [NAME] | Mr | 1947-11-26 00:00:00 | 22 Craigour Grove |  | Capitalburgh | QH17 7NP | 2 | 1947
 | Flockhart | Garry | Mr | 1976-10-26 00:00:00 | 8 Main Street | Eastglen | Forthside | GD14 5SR | 2 | 1976
 | [NAME] | [NAME] | Mr | 1973-05-13 00:00:00 | 2 Redding Road |  | Laurinch | PK2 9JU | 2 | 1973
 | [NAME] | [NAME] | Ms | 1965-05-28 00:00:00 | 7 Mitchell Place |  | Highstone | DY7 6DL | 2 | 1965
[NAME] | [NAME] | [NAME] | Ms |  | 19 Burleigh Road |  | Milnaross | [NAME] 7SS | 1 | 1900
Haven Homes | [NAME] | Andrina | Miss |  | 2 Pestgate |  | East Forthside | [NAME] 4AG | 1 | 1900
 | Jermain | [NAME] | Mr | 1950-12-19 00:00:00 | 48 Main Street |  | [NAME] | PK8 3US | 2 | 1950
Art Supply Company | Montgomery | [NAME] | Mrs |  | 6 Southesk Street |  | Stoneside | AD9 6EB | 1 | 1900
The Portrait Company | Calderwood | [NAME] | Mr |  | 5 Gas Brae | Westcarse | Bertha | BH2 7QR | 1 | 1900
 | [NAME] | [NAME] | Miss | 1973-10-24 00:00:00 | 8 Polmont Park | Polmont | Inverkirk | PK2 0XT | 2 | 1973
 | Farmer | [NAME] | Mrs | 1946-09-19 00:00:00 | 56 Rowallen Green |  | Laurinch | DY7 4SR | 2 | 1946
 | McConnel | Rosemary | Ms | 1953-05-05 00:00:00 | 81 [NAME] |  | Invercaldy | DY1 1XT | 2 | 1953
Health and [NAME] | Bell | [NAME] | Dr |  | 38 High Street |  | Selburgh | GD7 4JX | 1 | 1900
Leitch Telecommunications | Leitch | [NAME] | Mr |  | 54 Dolphinton Road | West Inch | [NAME] | QH46 7HS | 1 | 1900
Lend a Hand Group | Glennie | [NAME] | Mrs |  | Ancrum Court |  | Tayburgh | [NAME] | 1 | 1900
 | Sneddon | Ian | Mr | 1939-11-30 00:00:00 | 88 Station Road |  | Inverkirk | DY1 3ST | 2 | 1939
Sutherland's Biscuits | Sutherland | Agnes | Mrs |  | 56 Whitehill Road |  | Laurinch | DY6 2RP | 1 | 1900
 | [NAME] | [NAME] | Mr | 1952-03-14 00:00:00 | 6 Links Road |  | Inchneuk | DY8 4HZ | 2 | 1952
 | [NAME] | Kirsty | Mrs | 1953-03-11 00:00:00 | 6 Links Road |  | Inchneuk | DY8 4HZ | 2 | 1953
 | [NAME] | [NAME] | Mr | 1980-04-27 00:00:00 | 8 Kilrymont Road |  | [NAME] | DY16 8DQ | 2 | 1980
 | McDonald | [NAME] | Mrs | 1962-02-27 00:00:00 | 40 Bonnington Road |  | Duntay | AD11 2PY | 2 | 1962
The Garden Centre | McDonald | [NAME] | Mr |  | 67 [NAME] |  | Tayburgh | AD3 6PY | 1 | 1900
 | McKenzie | [NAME] | Mr | 1950-09-09 00:00:00 | 4 Erskine Street |  | Glenrose | AD10 9NT | 2 | 1950
 | [NAME] | Sandra | Ms | 1966-03-22 00:00:00 | 88 Pestray Terrace |  | Inverkirk | PK1 2PY | 2 | 1966
 | Simpson | Christina | Mrs | 1968-06-03 00:00:00 | 29 Davidson Terrace |  | Forthside | QH41 3AZ | 2 | 1968
 | Simpson | [NAME] | Mr | 1943-12-11 00:00:00 | 67 Grampian Road | Glenamul | Inveree | BH22 1RH | 2 | 1943
 | [NAME] | [NAME] | Dr | 1959-04-12 00:00:00 | 48 Crieff Road |  | Bertha | BH1 2PE | 2 | 1959
Computer Supplies | [NAME] | Anne | Mrs |  | 47 Bertha Street |  | Strathfermline | DY12 9SD | 1 | 1900
Sams Preserves | Sams | [NAME] | Ms |  | 8 Holly Road |  | [NAME] | DY11 4RT | 1 | 1900
The Cleaning Company | Benning | Sophie | Ms |  | 48 Ferret Avenue |  | Bertha | BH15 5AS | 1 | 1900
 | Wheel | [NAME] | Miss | 1979-11-03 00:00:00 | 23/4 Clarence Road | Boogle | Forthside | [NAME] | 2 | 1979
Lite Bulb Ltd | Spark | Brite | Mr |  | The Shining | Forest Way | Darkside | DF5 7YH | 1 | 1900
[NAME] | Axle | Grind | Ms |  | Rosetta |  | Peebles | PP8 2VB | 1 | 1900
Dodgy Deals | Daly | [NAME] | Mr |  | [NAME] |  | [NAME] Town | TT6 YU2 | 1 | 1900
 | Rabbit | [NAME] | Ms | 1965-09-23 00:00:00 | Loonytune Road |  | [NAME] Town | YU5 4RE | 2 | 1965
Titanic Tours | [NAME] | [NAME] | Ms |  | Anchor Point |  | [NAME] | SP9 5TA | 1 | 1900
[NAME] | [NAME] | Billy | Mr |  | Allsorts Avenue |  | Bassett Town | BA2 7UY | 1 | 1900
[NAME]'s Bloomers | Rose | Petal | Ms |  | Tulip Gardens |  | Riverlee | DR5 Q23 | 1 | 1900
 | Rabbit | Rodger | Mr | 1978-09-12 00:00:00 | Loonytune Road |  | [NAME] Town | YU5 4RE | 2 | 1978
 | [NAME] | Gina | Mrs | 1987-05-23 00:00:00 | Rue Lampost |  | Auchtermuchty | AA4 2DR | 2 | 1987
PromisesPromises | Tator | [NAME] | Mr |  | Industrial Wasteland |  | Edinburgh | EH77 2QQ | 1 | 1900
Long Shot Inc | Jones | Davey | Mr |  | PluPlus Avenue |  | [NAME] | GL8 34F | 1 | 1900
 | Murphy | Eddie | Mr | 1976-03-12 00:00:00 | Sunset Blvd |  | [NAME] Town | YU5 4RE | 2 | 1976
 | Plummer | [NAME] | Mr | 1948-06-03 00:00:00 | Belvue Park |  | [NAME] | SP9 5TA | 2 | 1948
 | Watson | Emily | Ms | 1983-06-06 00:00:00 | 28 Holly Road |  | [NAME] | DF5 7YH | 2 | 1983
 |  |  |  |  |  |  |  |  |  |  | Number Of Clients |  | annual income
 |  |  |  |  |  |  |  |  |  | Corporate Client | 40 |  | 4000
 |  |  |  |  |  |  |  |  |  | Personal Client | 43 |  | 860
 |  |  |  |  |  |  |  |  |  | Total | 83 |  | 4860
 |  |  |  |  |  |  |  |  |  | Male | 38
 |  |  |  |  |  |  |  |  |  | female | 45
 |  |  |  |  |  |  |  |  |  | Doctors | 45
 |  |  |  |  |  |  |  |  |  | Average year of birth | 48