COUNTIFS in Alteryx Designer

[RVDL]

Hi All,

I have the following table:

ID	TYPE	VALUE
ID1	T1
ID1	T2	X1
ID1	T3
ID1	T4
ID2	T1
ID2	T2
ID2	T3	Y2
ID2	T4
ID3	T1	X4
ID3	T2	Z6
ID3	T3
ID3	T4

I now want a new field, let's call it COUNT, that for each ID counts how many cells in column VALUE are blank for TYPE is T1 or T2. So I want to end up with a table like below.

ID	TYPE	VALUE	COUNT
ID1	T1		1
ID1	T2	X1	1
ID1	T3		1
ID1	T4		1
ID2	T1		2
ID2	T2		2
ID2	T3	Y2	2
ID2	T4		2
ID3	T1	X4	0
ID3	T2	Z6	0
ID3	T3		0
ID3	T4		0

How would I do this? Thanks for your help.

[Qiu]

@RVDL 
It is hard to say there is a specific workflow of pattern for CountIf function in Excel but usually it will involve Filter tool as "If" and Summarize tool as "Count".

For your case, we can do as below.

[AndrewDMerrill]

We can even simplify even further (at times) with the Formula Tool: