Spreadsheet: 729959d1619456090-countifs-a-range-is-not-blank-master-mi-v8-dummy-data-
Sheet: Clients

 |  | HMLO
 |  | HH |  |  |  |  |  | REPORT ELEMENTS
 | GV Ref | DW Shortname | Client Name | Current Client | System | BAU | PBI | MI | SLA | HS | PC | Headcount | Re-Referral | Triage Breakdown | Absence | Mental Health | Gender & Age | Test Outcomes | Financials | Scope Of Works | Deferred Pension | D & A Testing | VITA EAP Stats | RONA Stats | Physio | Survey Results | Total Reports | CSM | CTA TEAM | [NAME]
 | 1000051 | ACCEN
 | 1000137 | AIRPR
 | 1000216 | C3AMN
 | 1000350 | Atkin
 | 1000429 | [NAME]
 | 1000448 | BNY
 | 1000588 | Blab
 | 1000605 | C3Blo
 | 1000623 | BOCD
 | 1000727 | [NAME]
 | 1000755 | BT001
 | 1000800 | CAD
 | 1000823 | CAMBS
 | 1000859 | CPinn
 | 1000894 | catch
 | 1000900 | Cath
 | 1000939 | CHDA
 | 1001032 | COE
 | 1001048 | Cisco
 | 1001050 | CITB
 | 1001070 | COLC
 | 1001075 | [NAME]
 | 1001080 | Civil
 | 1001154 | OFT
 | 1001186 | CCBC
 | 1001254 | C3CS
 | 1001348 | DBCAR
 | 1001353 | DLR
 | 1001356 | DMU
 | 1001389 | DFE
 | 1001391 | DOT
 | 1001393 | DOH
 | 1001440 | DIXON
 | 1001504 | DVSA
 | 1001545 | EBC
 | 1001571 | [NAME]
 | 1001581 | EDVAC
 | 1001582 | EVEVW
 | 1001638 | ERM
 | 1001661 | FILTR
 | 1001719 | Farr
 | 1001889 | GAZP
 | 1001909 | Genti
 | 1001937 | GLEED
 | 1001982 | TSOL
 | 1002026 | GROS
 | 1002114 | HD
 |  | 0
 | 1002169 | IPS
 | 1002171 | B&HCa
 | 1002172 | [NAME]
 | 1002230 | LREG
 | 1002253 | HOHQ
 | 1002353 | [NAME]
 | 1002376 | ICO
 | 1002432 | IMG
 | 1002435 | INTSE
 | 1002436 | Inti
 | 1002437 | INTCO
 | 1002535 | Johns
 | 1002539 | TYCOI
 | 1002548 | JLL
 | 1002559 | JUD
 | 1002599 | KAM
 | 1002607 | KFC
 | 1002696 | LAW
 | 1002723 | LGEN1
 | 1002724 | LGMH1
 | 1002727 | Lcity
 | 1002729 | Leic
 | 1002757 | LTC
 | 1002759 | LFR
 | 1002766 | C3LL
 | 1002772 | [NAME]
 | 1002773 | LIV
 | 1002797 | LGO
 | 1002815 | LBH
 | 1002102 | [NAME]
 | 1002820 | LBHil
 | 1002821 | LBOHW
 | 1002832 | LBOTH
 | 1002837 | LonBC
 | 1002842 | LFB
 | 1002858 | SECUR
 | 1002896 | Mac
 | 1002901 | MB
 | 1002925 | MMU
 | 1002941 | MaCu
 | 1002943 | [NAME]
 | 1002953 | MARRH
 | 1002963 | C3Mar
 | 1002970 | MATAL
 | 1002998 | MDU
 | 1003013 | MeBC
 | 1003032 | MERAI
 | 1003040 | MET
 | 1003091 | MKC
 | 1003095 | MOJ
 | 1005488 | MTREL
 | 1003184 | C3Nan
 | 1003189 | NAO
 | 1003200 | NGOH
 | 1003214 | TRUST
 | 1004675 | ENSER
 | 1003279 | NHSE
 | 1003347 | NLANC
 | 1003371 | NCC
 | 1003401 | NWL
 | 1003433 | NSPCC
 | 1003474 | Ofst1
 | 1003475 | Ofst2
 | 1003493 | OpUni
 | 1003498 | Opteg
 | 1003519 | ORR
 | 1003568 | PPHE
 | 1003621 | PenPF
 | 1003650 | PHIL
 | 1003673 | PM
 | 1003678 | PIZZD
 | 1003680 | pizza
 | 1003761 | PromE
 | 1003778 | PHE
 | 1003822 | RADIA
 | 1003838 | RB
 | 1003972 | [NAME]
 | 1003982 | RMC
 | 1003999 | RCN
 | 1004011 | RMail
 | 1004012 | RMSPS
 | 1004013 | MENCA
 | 1003826 | #N/A
 | 1004054 | RYDER
 | 1004087 | Sanct
 | 1004176 | Serco
 | 1004297 | SOP
 | 1004335 | SWWL1
 | 1004414 | StJOH
 | 1004436 | SDRAI
 | 1004446 | LIFE
 | 1005409 | SLP
 | 1004582 | TATE
 | 1004590 | TECON
 | 1004623 | Tetro
 | 1004628 | THALE
 | 1004645 | TBS
 | 1004647 | TheBr
 | 1004694 | MILT
 | 1004698 | TNA
 | 1004711 | TPI
 | 1004860 | TRW
 | 1004890 | UBS
 | 1004915 | ULVR
 | 1004923 | Unite
 | 1004937 | UniUK
 | 1004986 | TUOS
 | 1005009 | UPS
 | 1005042 | VICSU
 | 1005052 | VC
 | 1005053 | VMed
 | 1005057 | Viriw
 | 1005074 | VOLVO
 | 1005109 | WARBU
 | 1005131 | Wate
 | 1000078 | ADDAC
 | 1005184 | WECC
 | 1005231 | WH
 | 1005243 | INSPA
 | 1005244 | Wilso
 | 1005249 | WIN
 | 1005264 | [NAME]
 | 1005311 | Xerox
 | 1005347 | [NAME]
 | 1003201 | NatGr
 | # No Acc | RPBTP