Count String

[arnorian_intapp]

Hi,

I have a simple spreadsheet with the following fields: account band, account name, product and sales).

I'm trying to create a formula that can count number of products that once i group by customer or account band can see number of products in that field. The product is written as a string (Name of the product).

I have tried COUNT STR(product) to no avail.

I have attached screenshot of sample data and type of output im trying to achieve.

Thanks

[Claje · Accepted solution]

Hi,

You can accomplish this with a Summarize tool and the Cross Tab tool.  In summarize, group by Account Band and Product, and count Products.  Then use the cross tab tool and set your "Account Band" field as the Group By value, set "Product" to headers, and set "Count" to values, and select the "Sum" option.

[Ganbatte]

Thanks @Claje. Your instruction is helpful.

[rippes]

Late to this post, but is there a way to select the max of each product per account. This is assuming I don't do the transpose