Spreadsheet: 776559d1649788043-sumifs-with-four-contions-criteria-and-help-with-dropdown-list-180
Sheet: Green_Street

 |  |  |  |  |  |  |  |  |  |  |  | '=SUMIFS(Sheet1!$G$4:$G$36,Sheet1!$D$4:$D$36,$B$5,Sheet1!$E$4:$E$36,Green_Street!$G$6,Sheet1!$F$4:$F$36,Green_Street!$G7)
 | Green_Street |  |  |  |  | Green_Street
 |  |  |  |  |  | Basement
 |  |  |  |  |  | OXFORD GLOBAL MARKETING LTD | 9375
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 47113.47
 |  |  |  |  |  | INHOME PRPERTY SOLUTIONS LTD | 182.63
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9
 |  |  |  |  |  | DTZ | 17.9
 |  |  |  |  |  | DTZ | 595.5
 |  |  |  |  |  | GREEN MAN LANE LLP | 26400
 |  |  |  |  |  | INHOME PRPERTY SOLUTIONS LTD | 182.63
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 82495.3
 |  |  |  |  |  | OXFORD GLOBAL MARKETING LTD | 8531.25
 |  |  |  |  |  | 4D Communications Ltd | 12350
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9
 |  |  |  |  |  | 4D Communications Ltd | 16466.66
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 4794.81
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 1200
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 1200
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 1200
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 1200
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 1200
 |  |  |  |  |  | OXFORD GLOBAL MARKETING LTD | 8531.25
 |  |  |  |  |  | 4D Communications Ltd | 16466.66
 |  |  |  |  |  | 4D Communications Ltd | 16466.66
 |  |  |  |  |  | 4D Communications Ltd | 24700
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9
 |  |  |  |  |  | [NAME] | 176
 |  |  |  |  |  | [NAME] | 176
 |  |  |  |  |  | 4D Communications Ltd | 929.51
 |  |  |  |  |  | first_floor
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 931.84
 |  |  |  |  |  | QUEEN'S WHARF RIVERSIDE LLP | 1507.81
 |  |  |  |  |  | OXFORD GLOBAL MARKETING LTD | 2502.01
 |  |  |  |  |  | OXFORD GLOBAL MARKETING LTD | 2502.01
 |  |  |  |  |  | LONDON BOROUGH OF HOUNSLOW | 120439.76
 |  |  |  |  |  | THISTLE TENANT RISKS | 200
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 509.6
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 724.36
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 742.56
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 866.32
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 910
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 1965.6
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 17086.16
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 934.75
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 1632
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 22295
 |  |  |  |  |  | QUEEN'S WHARF RIVERSIDE LLP | 1883.11
 |  |  |  |  |  | 4D Communications Ltd | 474.67
 |  |  |  |  |  | 4D Communications Ltd | 7071.11
 |  |  |  |  |  | OXFORD GLOBAL MARKETING LTD | 8531.25
 |  |  |  |  |  | 4D Communications Ltd | 24700
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 25.48
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 309.4
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 495.04
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 7247.24
 |  |  |  |  |  | Second_Floor
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 14259.09
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 965.91
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 3.64
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 103.13
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 152.88
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 200.2
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 225.68
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 225.68
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 353.08
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 356.72
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 371.28
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 389.48
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 444.08
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 531.44
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 549.64
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 600.6
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 622.44
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 637
 |  |  |  |  |  | Toilet
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 677.04
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 742.56
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 768.04
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 793.52
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 1015.56
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 2031.12
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 2464.28
 |  |  |  |  |  | QUEEN'S WHARF RIVERSIDE LLP | 84245.34
 |  |  |  |  |  | OSBORNE CLARKE | 180
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 522.37
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 803.14
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 3975.83
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 50.96
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 309.4
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 509.6
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 509.6
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 509.6
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 1361.36
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 2031.12
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 18767.84
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 965.91
 |  |  |  |  |  | NACRO | 106198.37
 |  |  |  |  |  | Disable_Toilet
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 72.8
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 101.92
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 196.56
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 465.92
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 1201.2
 |  |  |  |  |  | SURREY COUNTY COUNCIL | 18494.84
 |  |  |  |  |  | OXFORD GLOBAL MARKETING LTD | 4934.46
 |  |  |  |  |  | CASA CONTRACTS LTD | 3900
 |  |  |  |  |  | HAYES HOUGHTON LIMITED | 500
 |  |  |  |  |  | ORCHARD & SHIPMAN | 883.62
 |  |  |  |  |  | HOUSEMARK | 168.8
 |  |  |  |  |  | OXFORD GLOBAL MARKETING LTD | 8531.25
 |  |  |  |  |  | 4D Communications Ltd | 24700
 |  |  |  |  |  | PYRAMID PLUS LONDON LLP | 57197.08
 |  |  |  |  |  | PYRAMID PLUS SOUTH LLP | 63478.9