Countif function

[nguyentt1069]

I know alteryx does not have countif like excel. But how to count Y and N value.

for example 

WWE	WCW	MMA	UFC
Y	Y	N	Y
N	Y	N	N
N	Y	N	Y

I need help to count how many time WWE and WCW and MMA and UFC with Y and N.

[Qiu]

@nguyentt1069 
You mean something like this? 😁

[Raj]

@nguyentt1069 
although we do not have the count function like excel but we can achieve this in Alteryx with combination of tools
added the workflow.