Spreadsheet: 781702d1653494925-count-a-cell-that-is-blank-if-another-contains-text-mock-up-sheet
Sheet: Sheet1

Name | UserID
[NAME] | v541391C
[NAME] | v541384 |  |  | Number of users
Sreenivasulu | v541385 |  |  | Number of users with ID
[NAME] | v541606 |  |  | Number of users without ID set up |  | This one needs to only count the cell if column A contains a name
Pulolla | v541383
Pavani | v541386
[NAME] | v541382
[NAME] | v541381
Venu Kumar | v541380
[NAME] | v541379
Laxman | v541393
Venkata | v540532
[NAME] | v537947
Gloria | A180795
[NAME] | [NAME]
[NAME] | A180786
Shelina | v540402
[NAME] | v540401
[NAME] | A180792
[NAME] | v541209
Erden | v540403
Sai | v540128
Rishika | v540130
Nidhi | v540129
[NAME] | a180793
[NAME] | a180789
Ian | a180797
Amanda | a180784
[NAME] | a180799
[NAME] | a194857
[NAME] | a180803
Yuliya | a180805
Corrado | a180790
Fred | A182625
[NAME] | a180801
Reddepp | v541652
[NAME] Kumar | v541651
Sumit | v542092
[NAME] | v542091
[NAME] | A180709
[NAME] | A180707
Dalvir | A180691
Jo | A180697
Sue | A180721
[NAME] | A180711
[NAME] | A180918
[NAME] | A180928
[NAME] | A180936
Anneka | A180901
[NAME] | A180470
[NAME] | A180900
[NAME] | A181145
Abi | A180485
[NAME] | A180448
Cara | A180903
[NAME] | A182047
[NAME] | A180602
[NAME] | A181933
[NAME] | A180384
[NAME] | A181191
Clare | A181192
[NAME] | A180785
[NAME] | A193175
[NAME] | A180804
[NAME] | A180899
Kazim | A180892
[NAME] | A180908
[NAME] | A180700
Cathy | A180929
[NAME] | A180686
[NAME] | A180904
[NAME] | [NAME]
[NAME] | A180917
[NAME] | [NAME]
[NAME] | A193234
Beata | A180883
Liliana | A180914
Clare | A180905
[NAME] | A180931
[NAME] | A180687
[NAME] | A180932
[NAME] | A180920
[NAME] | A180701
Chhaya | [NAME]
[NAME] | A180945
[NAME] | A180712
[NAME] | A180933
[NAME] | A180921
[NAME] | A180885
Mark | A180706
[NAME] | A180930
[NAME] | A180896
[NAME] | A180688
Sandeep | A180718
Purushotham | v542078
Ian | v542077
Beverley | v542076
[NAME] | v542075
[NAME]
Madalina
Ravish | V542320
Vivek | V542319
[NAME] | V542318
Biswajeet | V542317
[NAME] | V542316
Nikhil | V542315
Kaushik | V542314
Karthick
Rujal | V542313
[NAME] | V542312
Sandeep | V542311
Madhu | V542310
Sandra | V542309
[NAME]
Somesh | v542375
[NAME] | [NAME]
Sourav | V542441
Vijayarajeswari | V542513
Swathi | V542626
Bharat | V542741
Vivek | V542744
[NAME] | V542745
[NAME] | V542743
[NAME] | A180915
[NAME] | A180893
Bolla | V542850
Ramya | V542851
Sujeet | V542849
Devbrat | V542848
Daren | A193139
[NAME] | A193119
Greg | A182012
Sathish | V542889
Kris | V542998
Ramasamy
Minnala | V542997
Gurpreet | [NAME]
Manikandan
Yogita
Rahul
[NAME]
Shruti
[NAME]
Ateka
Asanka
[NAME]
[NAME]
[NAME]
[NAME] | A180706
Amanda
Becky
[NAME]
Caroline
[NAME]
[NAME]
[NAME]
[NAME]
Debbie
[NAME]
[NAME] | A180907
Enike
Elaine
Eleni
Fraz
[NAME]
Gemma
[NAME]
Julie
[NAME] | A199915
Javeen
[NAME]
[NAME]
[NAME]
[NAME]
Julie
Helen
Hanna
Heather
Kejalkumar
[NAME]
[NAME]
[NAME]
Kala
[NAME]
[NAME]
[NAME]
Leo
Lester
Luidmyia
[NAME]
[NAME]
Lauren
[NAME]
[NAME]
Lewis
[NAME]
Milihat
Mark
Malgorzata
Natalia
[NAME]
Madeline
Maria
Mpande
Michelle
Nim
[NAME]
Rebecca
[NAME]
Rebecca
Stuart
[NAME]
[NAME]
[NAME]
[NAME]
Stephen
Stana
[NAME]
[NAME]
Sumaiya
[NAME]
Samantha
Vithya
Veronic
[NAME]
[NAME]
[NAME]
Tamara
Victoria