Count Across Multiple Columns in a single row

[Ankitdaim]

Hi All,

I am trying to do a count in the below data. Basically I want to calculate to how many companies among the 5 companies in the table below is Microsoft supplying to. So based on the table below the answer is 3. Like this I have around 78K suppliers for whom I am trying to do this. So in the end I want to have new columns called "# suppliers" which counts the number of companies each supplier is supplying to. 

I have tried to use the formula tool to do a count but it is not working. I have also tried to do a transpose to turn the companies into rows and then do a count by summarize tool but that also is not working.

Would really appreciate any assistance on this. 

Supplier Name	Company A	Company B	Company C	Company D	Company E
Microsoft	0	0	30	2	1
Apple	2	13	0	0	3
Amazon	1	2	22	0	1

[BenMoss · Accepted solution]

Hi @Ankitdaim ; I've attached a working example for you which uses the summerize tool.

In future, if you have tried a solution and it doesn't work, make sure you post this too so we can understand what you have tried and give you some guidance, rather than us providing you with the solution directly. The reason for this would be 2-fold, firstly it will help you learn, and secondly it prevents us encountering the issues you have hit.

Ben

[Ankitdaim · Accepted solution]

Thanks @benMoss for the quick response.

I understand what you are saying with regards to posting the solution i have tried, will do that in future. 

Ankit

[BenMoss]

@Ankitdaim no problem at all! Please, if the post bought you to a solution, can you mark this as such. Articles which are marked as a solution are likely to get far more views from people searching and trying to resolve a problem than those that do not.

Ben

[Ankitdaim]

Done