Counting "First Pass" and Subsequent results

[poor_cookie]

Hi, I would like to count the number of the first passes based on a list of IDs. What formula can i write to calculate the sum of all unique first pass IDs?

i.e: ID 1 with PASS (Row 2 ) is a first Pass.
ID 2 with PASS (Row 3) is a first Pass.
ID 2 with a PASS (Row 4) is not a first Pass.
ID 4 with a PASS (Row 10) is not a first Pass - because it failed in Row 8 and 9.

From the table, the number should be: 2 (Only Row 2 and Row 3 are unique first Pass IDs)

The additional complexity is : After identifying the unique first pass IDs, I would like to identify the unique IDs for subsequent passes.
i.e.:
ID 2 with a PASS (Row 4) is not a subsequent pass as there is already a first past earlier.
ID 4 with a PASS (Row 10) is considered as a subsequent pass, as the earlier Statuses for this ID are FAIL.

This is pretty challenging for me as a beginner. Many thanks for the help.

 

[StephenCrump]

Only lightly tested, but I think this works:

	A	B	C
1	ID	Status
2	1	PASS
3	2	PASS
4	2	PASS
5	2	FAIL
6	3	FAIL
7	3	FAIL
8	4	FAIL
9	4	FAIL
10	4	PASS
11
12		First PASS	2
13		Subsequent PASS	1
Sheet1

Cell Formulas
Range	Formula
C12	C12	=SUMPRODUCT((MATCH(A2:A10,A2:A10,)=(ROW(A2:A10)-ROW(A2)+1))*(B2:B10="PASS"))
C13	C13	=SUMPRODUCT(--(IFERROR(MATCH(A2:A10&"PASS",A2:A10&B2:B10,)=ROW(A2:A10)-ROW(A2)+1,0)))-C12