count and sum occurrence against a value

I have two sheets, sheet 1 has names with total counts of statuses. I want to count the number of active and deactivated entries against each name.

This is a blank sheet.
Please upload proper example.

my bad, I'm attaching the correct one. thanks for a quick response

Here:

Formula:

Please Login or Register  to view this content.

Watch out on $ distribution in formula.

perfecto