Spreadsheet: 135887d1326293373-sumif-and-with-a-filter-excel-upload-paste-into-pivot-table
Sheet: Client Lookup

Code | Name
111 | test 1
111 | test 2
111 | test 3
111 | test 4
111 | test 5
111 | test 6
111 | test 7
111 | test 8
111 | test 9
111 | test 10
111 | test 11
111 | test 12
111 | test 13
111 | test 14
111 | test 15
111 | test 16
111 | test 17
111 | test 18
111 | test 19
111 | test 20
111 | test 21
111 | test 22
111 | test 23
111 | test 24
3I | test 25
ABG | test 26
ABP | test 27
ACT | test 28
ACU | test 29
ADU | test 30
AER | test 31
AFR | test 32
AFR | test 33
AGE | test 34
AGO | test 35
AIU | test 36
ALF | test 37
ALL | test 38
ALL | test 39
ALM | test 40
ALP | test 41
ALT | test 42
AMD | test 43
AMJ | test 44
APF | test 45
ARC | test 46
ARC | test 47
ARC | test 48
ARC | test 49
ARE | test 50
ARG | test 51
ARK | test 52
ARL | test 53
ARM | test 54
ARQ | test 55
ASP | test 56
AST | test 57
AST | test 58
ATT | test 59
AUT | test 60
AUT | test 61
AVI | test 62
AXA | test 63
AXE | test 64
B&B | test 65
B&B | test 66
[NAME] | test 67
BAB | test 68
BAE | test 69
BAI | test 70
BAP | test 71
BAR | test 72
[NAME] | test 73
BBC | test 74
BEC | test 75
BEI | test 76
BEL | test 77
BEZ | test 78
BLG | test 79
BLM | test 80
BMG | test 81
BNF | test 82
BON | test 83
BOO | test 84
BOR | test 85
BOZ | test 86
BP | test 87
BPB | test 88
BRA | test 89
BRA | test 90
BRE | test 91
BRI | test 92
BRI | test 93
BRI | test 94
BRN | test 95
BRT | test 96
BRU | test 97
BSB | test 98
BUN | test 99
BUO | test 100
BUP | test 101
BUR | test 102
BUY | test 103
C&W | test 104
CA | test 105
CAD | test 106
CAF | test 107
CAG | test 108
CAN | test 109
CAP | test 110
CAP | test 111
CAR | test 112
CAR | test 113
CAT | test 114
CED | test 115
CEN | test 116
CEN | test 117
CH2 | test 118
CHA | test 119
CHI | test 120
CHU | test 121
CIH | test 122
CIN | test 123
CIN | test 124
CIT | test 125
CLI | test 126
CMC | test 127
CNT | test 128
COL | test 129
COM | test 130
COM | test 131
CON | test 132
COR | test 133
COR | test 134
COR | test 135
CPI | test 136
CPO | test 137
CRE | test 138
CRH | test 139
CRL | test 140
CRO | test 141
CRS | test 142
CUK | test 143
DAN | test 144
DAR | test 145
DAT | test 146
DAV | test 147
DBE | test 148
DEU | test 149
DIA | test 150
DIL | test 151
DIX | test 152
DKR | test 153
DRA | test 154
DRI | test 155
DUB | test 156
DUR | test 157
EAS | test 158
EBA | test 159
EBC | test 160
ECO | test 161
EDI | test 162
EDI | test 163
EIR | test 164
ELA | test 165
ELE | test 166
ELL | test 167
EMI | test 168
ENE | test 169
ENG | test 170
ENI | test 171
ENI | test 172
ENO | test 173
ENT | test 174
EO | test 175
EQL | test 176
EQU | test 177
EQU | test 178
ERN | test 179
ERP | test 180
ESS | test 181
ETO | test 182
EUR | test 183
EVE | test 184
EXN | test 185
EXP | test 186
F&C | test 187
F1 | test 188
FAP | test 189
FAR | test 190
FAS | test 191
FER | test 192
FHU | test 193
FIL | test 194
FIP | test 195
FIP | test 196
FIT | test 197
FOR | test 198
FOR | test 199
FOR | test 200
FRA | test 201
FRI | test 202
FRS | test 203
FRV | test 204
FTN | test 205
GAL | test 206
GAR | test 207
GAT | test 208
GEN | test 209
GFR | test 210
GLA | test 211
GLA | test 212
GLE | test 213
GLG | test 214
GLO | test 215
GLO | test 216
GNN | test 217
GNR | test 218
GOL | test 219
GOV | test 220
GRE | test 221
GRO | test 222
GTA | test 223
GUS | test 224
HAB | test 225
HAB | test 226
HAB | test 227
HAL | test 228
HAR | test 229
HAW | test 230
HAW | test 231
HBF | test 232
HEA | test 233
HEI | test 234
HEI | test 235
HEL | test 236
HHG | test 237
HIL | test 238
HIT | test 239
HIV | test 240
HLT | test 241
HMV | test 242
HOC | test 243
HSB | test 244
HUN | test 245
HUV | test 246
IFP | test 247
IKO | test 248
IMI | test 249
INC | test 250
IND | test 251
ING | test 252
INM | test 253
INS | test 254
INT | test 255
INV | test 256
IPD | test 257
IPF | test 258
ITA | test 259
ITS | test 260
JLT | test 261
[NAME] | test 262
JPM | test 263
KAT | test 264
KCC | test 265
KEL | test 266
KES | test 267
KID | test 268
KIE | test 269
KIL | test 270
KIN | test 271
KIO | test 272
KKR | test 273
KON | test 274
KRO | test 275
LAD | test 276
LAI | test 277
LAN | test 278
LAP | test 279
LEM | test 280
LEN | test 281
LLO | test 282
LLO | test 283
LON | test 284
LOT | test 285
LOT | test 286
LUN | test 287
MAN | test 288
MAN | test 289
MAR | test 290
MAR | test 291
MEP | test 292
MER | test 293
MET | test 294
MEY | test 295
MFG | test 296
MGC | test 297
MGM | test 298
MGN | test 299
MIL | test 300
MKM | test 301
MMK | test 302
MNG | test 303
MON | test 304
MON | test 305
MOR | test 306
MOT | test 307
MOU | test 308
MRG | test 309
MRX | test 310
MSD | test 311
MTI | test 312
MUB | test 313
MUL | test 314
NAT | test 315
NCL | test 316
NEW | test 317
NOM | test 318
NOM | test 319
NOM | test 320
NOM | test 321
NOM | test 322
NOO | test 323
NOR | test 324
NOS | test 325
NOV | test 326
NTH | test 327
NU | test 328
NWS | test 329
OBE | test 330
OCH | test 331
OEP | test 332
OFG | test 333
OLD | test 334
OLD | test 335
OND | test 336
OPE | test 337
ORA | test 338
ORB | test 339
PAC | test 340
PAF | test 341
PAY | test 342
PBN | test 343
PED | test 344
PEN | test 345
PIL | test 346
PLA | test 347
PLI | test 348
PNN | test 349
POL | test 350
POL | test 351
POS | test 352
PRE | test 353
PRP | test 354
PRS | test 355
PUN | test 356
PUN | test 357
RAC | test 358
RAI | test 359
RAI | test 360
RAS | test 361
RBS | test 362
RDD | test 363
RDF | test 364
RED | test 365
REE | test 366
REO | test 367
RIO | test 368
RLM | test 369
ROA | test 370
ROB | test 371
ROC | test 372
ROG | test 373
ROL | test 374
ROM | test 375
RP | test 376
RSA | test 377
RSI | test 378
RSR | test 379
RTL | test 380
RUK | test 381
RUS | test 382
RWE | test 383
RWE | test 384
RYM | test 385
SAC | test 386
[NAME] | test 387
[NAME] | test 388
SAI | test 389
SAN | test 390
SCA | test 391
SCA | test 392
SCH | test 393
SCT | test 394
SEN | test 395
SER | test 396
SHA | test 397
SHE | test 398
SHE | test 399
SHS | test 400
SI | test 401
SIG | test 402
SIL | test 403
SIX | test 404
SIX | test 405
SJB | test 406
SNA | test 407
SPE | test 408
SSI | test 409
STA | test 410
STI | test 411
STO | test 412
STR | test 413
SVP | test 414
TAB | test 415
TAY | test 416
TCC | test 417
TCC | test 418
TDC | test 419
TEL | test 420
TEL | test 421
TEL | test 422
TEM | test 423
TER | test 424
TET | test 425
THA | test 426
THC | test 427
THM | test 428
TI | test 429
TIS | test 430
TOM | test 431
TPG | test 432
TRA | test 433
TRA | test 434
TRC | test 435
TRD | test 436
TRI | test 437
TRR | test 438
TRR | test 439
TRV | test 440
TYN | test 441
UDP | test 442
UNI | test 443
UNI | test 444
UPC | test 445
URA | test 446
UVI | test 447
VED | test 448
VIN | test 449
VIR | test 450
VIT | test 451
VLL | test 452
VNU | test 453
VOD | test 454
VRS | test 455
WAV | test 456
WAY | test 457
WDE | test 458
WDE | test 459
WEL | test 460
WEL | test 461
WES | test 462
WIT | test 463
WON | test 464
WOO | test 465
WPD | test 466
WST | test 467
XAF | test 468
XST | test 469
YAH | test 470
YEL | test 471