Count # of items at their furthest point along in a process

[mbk0523]

How do I count the number of items at their furthest point in a process. A couple examples:
-- In an 8-phase process, it's easy to count any of the items that made it to phase 8 or to phase 7, but how do I count how many made it to phase 7 without making it to phase 8?
--Similarly, when tracking items that dropped out of the process at various phases, how do I count how many dropped out at each distinct phase?

Example mini-sheet attached. Yellow-colored cells are hardcodes that I'm looking to satisfy via formula (& your help!) Thank you!

count example.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N
3		Phase 1	Phase 2	Phase 3	Phase 4	Phase 5	Phase 6	Phase 7	Phase 8	Phase 9	Phase 10	Phase 11	Phase 12
4	Active
5	A	x	x	x	x	x	x	x	x
6	B	x	x	x	x	x	x	x	x
7	C	x	x	x	x	x	x	x
8	D	x	x	x	x	x	x	x
9	E	x			x	x	x	x
10	F	x			x	x	x
11	G	x			x	x	x
12	H	x			x	x	x
13
14	Inactive
15	I	x	x	x
16	J	x	x	x
17	K	x			x
18	L	x			x
19	M	x	x	x	x	x	x	x
20
21	TOTAL
22	Active	8	4	4	8	8	8	5	2	0	0	0	0
23	Inactive	5	3	3	3	1	1	1	0	0	0	0	0
24
25	CURRENT PHASE
26	Active	0	0	0	0	0	3	3	2
27	Inactive	0	0	2	2	0	0	1	0
Sheet1

Cell Formulas
Range	Formula
C22:N22	C22	=COUNTA(C5:C12)
C23:N23	C23	=COUNTA(C15:C19)

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)