Good Day!

I have a worksheet having "Names" in one column and "Status" (Pending or Complete) in the other column. I want to check name by comparing the status.

I mean to say that suppose how many jobs "James" has completed and how many are pending with him and so on with other names. I tried to use Vlookup and countif functions at the same time but no required result found.

Please help me to resolve this issue.

Thanks & Regards,
Umran