How do I count number of entries across multiple fields?

[benmillea]

Please see screenshot - is there a way for me to sum up how many "Y" entries there are for each Machine Id? What I need is a "Total" column at the end which will be populated with the number of "Y" entries through the week:

Machine Id	Total
25	4
26	1
27	3
28	4

Thank you

[binu_acs]

@benmillea Transpose your data (Machine id as the key column)- filter out only Y values, summarise tool group by Machine ID, count of value

[Qiu]

@benmillea 
I can think of a few ways of doing it including the one from @binu_acs 😂

[atcodedog05 · Accepted solution]

Hi @benmillea,

I also wanted to throw my solution into the hat😁. I am using a shorter version of IF statement to write my logic.

Cheers and Happy Analyzing :)

atcodedog05 

[benmillea]

Many thanks, everyone. Much appreciated 😊

[atcodedog05]

Happy to help : ) @benmillea 

Cheers and have a nice day!