Hi,

I have tried to find ideas to resolve the problem below but I don't seem to find the right answer.
I have data on projects conducted by different firms. Each firm might have different projects. One of the variables indicates if the project was ceased (1) or was successfully completed (0). I need to count how many firms only have ceased projects and how many only successful projects.

For example, for the below data it should yield that two companies have all projects ceased (x and xy) and one firm has all projects successfully completed (y).
Firm Ceased
X 1
X 1
X 1
y 0
y 0
y 0
y 0
z 1
z 0
z 0
z 1
z 0
xy 1
xy 1
xy 1
xy 1
xy 1
Thanks
Best regards
Antonio