Count on Different condition

[Umesh Chahar]

Hi ,
i got stuck on a very complex count . the situation is, i have to count the rows where the status is completed based on the different names.
the data is as follows .

now i have to count the number of rows where the status is completed only if the Analyst Name is . Excel sheets is also attached along with the query .
Arvind ,Neha, Parvinder Abhishek ,,Bramhanand ,Shikha

Analyst Name Status
Shikha in work
Neha completed
Neha completed
Parvinder completed
Parvinder completed
Bramhanand completed
Abhishek completed
Bramhanand completed
Abhishek completed
Neha completed
Abhishek completed
Bramhanand completed
HCL in work
Arvind in work
Parvinder completed
Bramhanand completed
Parvinder completed
Bramhanand completed
Neha in work
Bramhanand completed
Abhishek in work
Bramhanand completed
Parvinder in work
Bramhanand completed
Abhishek completed
Neha in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
HCL in work
Abhishek in work
Abhishek in work
Adams completed
HCL in work
HCL in work
Dae completed
Yang completed
Carlos completed
Chris in work
Rahim in work
Dae in work
Dae in work
Dae in work
Adams completed
Adams completed
Adams completed
Adams completed
Adams completed
Adams completed
Yang completed
Yang completed
Jing_local in work
Jing_local in work
Jing_local in work
Jing_local in work
Jing_local in work
Jing_local in work
Jing_local in work
Jing_local in work
Ying_Local in work
Ying_Local in work
Ying_Local in work
Ying_Local in work
Ying_Local in work
Ying_Local in work
Ying_Local in work
Ying_Local in work
Ying_Local in work
Ying_Local in work
Atif completed
Atif completed
Atif in work
Atif in work
Atif in work
Atif in work
Atif in work
Atif in work
Atif in work
Hong in work
Hong in work
Bramhanand completed
Hong in work
Hong in work
Hong in work
Hong in work
Hong in work
Hong in work
Adams completed
Jason_local in work
Jason_local in work
Jason_local in work
Jason_local in work
Jason_local in work
Jason_local in work
Jason_local in work
Jason_local in work
Jason_local in work
Jason_local in work
Adams completed
Yang completed
Yang in work
Francisco in work
Francisco in work
Francisco in work
Carlos in work
Carlos in work
Carlos in work
Carlos in work
Carlos in work
Carlos in work
Adams completed
Atif_Local in work
Atif_Local in work
Atif_Local in work
Neha in work
Neha in work
Abhishek in work
Neha in work
Abhishek completed
Bramhanand in work
Atif_Local in work
Adams completed
Adams completed
Adams in work
Adams in work
Adams in work
Adams in work
Adams in work
Adams_Local in work
Adams_Local in work
Adams_Local in work
Adams_Local in work
Adams_Local in work
Adams_Local in work
Adams completed
Adams completed
Vimal in work
Vimal in work
Vimal_Local in work
Vimal_Local in work
Vimal_Local in work
Vimal_Local in work
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
Adams completed
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
untouched
Adams completed
untouched
untouched
untouched

 

[vletm]

Umesh Chahar
Something like this?

 

[Umesh Chahar]

Thanks for the suggesstion .its is fantastic and working fine . thanks a lot