Count Unique Values with and without Criteria

[jedilefty]

Hello all! I'm having trouble counting the number of times a value appears and how many times based on criteria from another cell. I want to calculate how many times a Sales Order is listed. And I also want to calculate how many Sales Order are affected by Inventory Lvl being at "0." Some Sales Orders could have multiple items with 0 inventory. Any help would be awesome! (I have the data stored in a table if that matters at all)

Here is how my spreadsheet looks:

Sales Order	Part	Inventory Lvl
1	a	0
1	b	2
2	c	0
3	e	0
2	f	5
3	g	0
4	f	5

 

[Skybluekid]

Try

Book1.xlsm
	A	B	C	D	E	F	G	H
1	Sales Order	Part	Inventory Lvl		Sales Order	Count	Inventory Lvl
2	1	a	0		1	2	1
3	1	b	2		2	2	1
4	2	c	0		3	2	2
5	3	e	0		4	1	0
6	2	f	5
7	3	g	0
8	4	f	5
9
Sheet6

Cell Formulas
Range	Formula
E2:E5	E2	=UNIQUE(A2:A8)
F2:F5	F2	=COUNTIF(A2:A8,E2#)
G2:G5	G2	=COUNTIFS(A2:A8,E2#,C2:C8,0)
Dynamic array formulas.