Spreadsheet: 767309d1644405088-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Interview Data

Candidate Name | [NAME] | [NAME] | Position | Location | Status | Online Test Status | Round 1-Status | Round 2-Status | Round 3-Status
Candidate-1 |  | 2020-10-14 00:00:00 | SE | India | Rejected (1st) |  | Rejected
Candidate-2 |  | 2020-10-14 00:00:00 | SE | India | Rejected (1st) |  | Rejected
Candidate-3 |  | 2020-10-14 00:00:00 | SE | India | No Show |  | No Show
Candidate-4 |  | 2020-10-14 00:00:00 | SE | India | No Show |  | No Show
Candidate-5 |  | 2020-10-14 00:00:00 | SE | India | Not Interested
Candidate-6 |  | 2020-10-22 00:00:00 | SE | India | Declined Offer |  | Selected | Selected
Candidate-7 |  | 2020-10-22 00:00:00 | SE | India | No Show |  | Selected | No Show
Candidate-8 |  | 2020-10-22 00:00:00 | SE | India | Not Interested
Candidate-9 |  | 2020-10-30 00:00:00 | SE | India | Rejected (1st) |  | Rejected
Candidate-10 |  | 2020-11-05 00:00:00 | SE | India | Offer Accepted |  | Selected | Selected
Candidate-11 |  | 2020-11-11 00:00:00 | SE | India | Rejected (Final) |  | Selected | Rejected
Candidate-12 |  | 2020-11-17 00:00:00 | SE | India | Not Interested |  | Selected | No Show
Candidate-13 |  | 2020-11-17 00:00:00 | SE | India | Not Suitable
Candidate-14 |  | 2020-11-17 00:00:00 | SE | India | Duplicate
Candidate-15 |  | 2020-11-17 00:00:00 | SE | India | Rejected (1st) |  | Rejected
[NAME] |  | 2020-11-17 00:00:00 | SE | India | Not Interested
Candidate-17 |  | 2020-11-18 00:00:00 | SE | India | Rejected (1st) |  | Rejected
Candidate-18 |  | 2020-11-18 00:00:00 | SE | India | Rejected (1st) |  | Rejected
Candidate-19 |  | 2020-11-18 00:00:00 | SE | India | Rejected (1st) |  | Rejected
Candidate-20 |  | 2020-11-27 00:00:00 | SE | India | Rejected (1st) |  | Rejected
[NAME] |  | 2020-11-27 00:00:00 | SE | India | Not Interested
Candidate-22 |  | 2021-03-05 00:00:00 | [NAME] | India | Rejected (1st) | Rejected (1st) | Rejected
Candidate-23 |  | 2021-03-05 00:00:00 | [NAME] | India | Not Suitable
Candidate-24 |  | 2021-03-05 00:00:00 | [NAME] | India | Not Interested
Candidate-25 |  | 2021-03-05 00:00:00 | [NAME] | India | Rejected (1st) | Rejected (1st) | Rejected
Candidate-26 |  | 2021-03-05 00:00:00 | [NAME] | India | Not Suitable
Candidate-27 |  | 2021-03-05 00:00:00 | [NAME] | India | Not Suitable
Candidate-28 |  | 2021-03-09 00:00:00 | [NAME] | India | Not Interested
Candidate-29 |  | 2021-03-09 00:00:00 | [NAME] | India | Not Suitable
Candidate-30 |  | 2021-03-09 00:00:00 | [NAME] | India | Not Interested
Candidate-31 |  | 2021-01-04 00:00:00 | PSM | India | Not Interested
Candidate-32 |  | 2021-01-04 00:00:00 | PSM | India | Not Interested
[NAME] |  | 2021-01-08 00:00:00 | PSM | India | Rejected (1st) |  | Rejected
Candidate-34 |  | 2021-01-12 00:00:00 | PSM | India | Rejected (2nd) |  | Selected | Rejected
Candidate-35 |  | 2021-01-13 00:00:00 | PSM | India | Not Interested
Candidate-36 |  | 2021-01-22 00:00:00 | PSM | India | Rejected (1st) |  | Rejected
Candidate-37 |  | 2021-01-22 00:00:00 | PSM | India | Rejected (1st) |  | Rejected
Candidate-38 |  | 2020-11-15 00:00:00 | CCT | India | Rejected (2nd) |  | Selected | Rejected
Candidate-39 |  | 2020-11-15 00:00:00 | CCT | India | No Show |  | Selected | No Show
Candidate-40 |  | 2020-11-15 00:00:00 | CCT | India | No Show |  | Selected | No Show
Candidate-41 |  | 2020-11-15 00:00:00 | CCT | India | No Show |  | No Show
Candidate-42 |  | 2020-11-08 00:00:00 | CCT | India | No Show |  | Selected | Assignment Issued
Candidate-43 |  | 2021-01-15 00:00:00 | CCT | India | Offer Accepted |  | Selected | Assignment Issued | Selected
Candidate-44 |  | 2021-01-15 00:00:00 | CCT | India | Not Suitable
Candidate-45 |  | 2021-01-21 00:00:00 | CCT | India | Not Suitable
Candidate-46 |  | 2021-01-21 00:00:00 | CCT | India | Not Suitable
Candidate-47 |  | 2021-01-21 00:00:00 | CCT | India | Not Suitable
Candidate-48 |  | 2021-08-03 00:00:00 | [NAME] | India | Not Interested
[NAME] |  | 2021-08-03 00:00:00 | [NAME] | India | Rejected (1st) | Selected | Rejected
Candidate-50 |  | 2021-08-03 00:00:00 | [NAME] | India | Rejected - Online Test | Rejected - Online Test
Candidate-51 |  | 2021-08-03 00:00:00 | [NAME] | India | Rejected - Online Test | Rejected - Online Test
Candidate-52 |  | 2021-08-03 00:00:00 | [NAME] | India | No Show
Candidate-53 |  | 2021-08-03 00:00:00 | [NAME] | India | Not Suitable
Candidate-54 |  | 2021-08-03 00:00:00 | [NAME] | India | Rejected (1st) | Selected | Rejected
Candidate-55 |  | 2021-08-03 00:00:00 | [NAME] | India | Not Interested
Candidate-56 |  | 2021-08-03 00:00:00 | [NAME] | India | No Show
Candidate-57 |  | 2021-08-03 00:00:00 | [NAME] | India | Rejected (1st) | Selected | Rejected
Candidate-58 |  | 2021-08-03 00:00:00 | [NAME] | India | Rejected - Online Test | Rejected - Online Test
Candidate-59 |  | 2021-08-03 00:00:00 | [NAME] | India | Rejected - Online Test | Rejected - Online Test
Candidate-60 |  | 2021-08-03 00:00:00 | [NAME] | India | Not Interested
Candidate-61 |  | 2021-08-03 00:00:00 | [NAME] | India | No Response
Candidate-62 |  | 2021-08-03 00:00:00 | [NAME] | India | Not Suitable
Candidate-63 |  | 2021-08-03 00:00:00 | [NAME] | India | Not Suitable
Candidate-64 |  | 2021-08-03 00:00:00 | [NAME] | India | Not Suitable
Candidate-65 |  | 2021-09-02 00:00:00 | SQA | India | Not Interested
Candidate-66 |  | 2021-09-02 00:00:00 | SQA | India | Not Interested
Candidate-67 |  | 2021-09-13 00:00:00 | SQA | India | Not Interested
Candidate-68 |  | 2021-09-13 00:00:00 | SQA | India | Not Interested
Candidate-69 |  | 2021-09-13 00:00:00 | SQA | India | Not Interested
[NAME] |  | 2021-09-13 00:00:00 | SQA | India | Not Interested
Candidate-71 |  | 2021-09-22 00:00:00 | SQA | India | No Show
Candidate-72 |  | 2021-09-22 00:00:00 | SQA | India | Rejected (1st) |  | Rejected
Candidate-73 |  | 2021-09-22 00:00:00 | SQA | India | Rejected (1st) |  | Rejected
Candidate-74 |  | 2021-09-30 00:00:00 | SQA | India | No Show
Candidate-75 |  | 2021-09-30 00:00:00 | SQA | India | Not Interested
Candidate-76 |  | 2021-09-30 00:00:00 | SQA | India | Offer Accepted |  | Selected | Selected | Selcted
Candidate-77 |  | 2021-09-30 00:00:00 | SQA | India | Not Suitable
Candidate-78 |  | 2021-09-30 00:00:00 | SQA | India | No Show |  | No Show
Candidate-79 |  | 2021-09-30 00:00:00 | SQA | India | No Show
Candidate-80 |  | 2021-09-30 00:00:00 | SQA | India | Rejected (1st) |  | Rejected
Candidate-81 |  | 2021-09-30 00:00:00 | SQA | India | Not Suitable
Candidate-82 |  | 2021-09-30 00:00:00 | SQA | India | Not Suitable
Candidate-83 |  | 2021-09-30 00:00:00 | SQA | India | Not Suitable
[NAME] |  | 2021-09-30 00:00:00 | SQA | India | No Show |  | No Show
Candidate-85 |  | 2021-10-08 00:00:00 | SQA | India | Rejected (2nd) |  | Selected | Rejected
Candidate-86 |  | 2021-10-08 00:00:00 | SQA | India | Rejected (1st) |  | Rejected
Candidate-87 |  | 2021-10-20 00:00:00 | TAS | India | No Response
[NAME] |  | 2021-10-20 00:00:00 | TAS | India | Not Interested
Candidate-89 |  | 2021-10-20 00:00:00 | TAS | India | No Response
Candidate-90 |  | 2021-10-20 00:00:00 | TAS | India | Not Interested
Candidate-91 |  | 2021-10-20 00:00:00 | TAS | India | No Response
Candidate-92 |  | 2021-10-20 00:00:00 | TAS | India | No Response
Candidate-93 |  | 2021-12-17 00:00:00 | Web Designer | India | Not Suitable
Candidate-94 |  | 2022-01-19 00:00:00 | Web Designer | India | Suitable
Candidate-95 |  | 2022-01-19 00:00:00 | Web Designer | India | Suitable
Candidate-96 |  | 2022-01-19 00:00:00 | Web Designer | India | Suitable
Candidate-97 |  | 2022-01-19 00:00:00 | Web Designer | India | Suitable
Candidate-98 |  | 2022-01-19 00:00:00 | Web Designer | India | Suitable
Candidate-99 |  | 2022-01-19 00:00:00 | Web Designer | India | Not Suitable
Candidate-100 |  | 2022-01-24 00:00:00 | Web Designer | India | Suitable
Candidate-101 |  | 2022-01-20 00:00:00 | Fresher | India | Rejected-Online Test
Candidate-102 |  | 2022-01-20 00:00:00 | Fresher | India | Rejected-Online Test
Candidate-103 |  | 2022-01-20 00:00:00 | Fresher | India | In Progress