Multiple Column Summaries

Jennifer Vaughn

Hello SS Community,

I am trying to create a summary of data from 2 different columns. The first column is "Industry Type" (there are 7 different types). The second column is the amount of ($'s) for that industry and client. EX: Client 1 - Industry type "Distribution", $5,000. Client 2 - Industry type "Other", $3,000. This will continue for multiple clients and repeating industry. I want to create a formula that will SUM the ($'s) for each industry. Ex: Distribution Total = $15,000. This will give me the total pipeline for each industry. Please provide a solution. Thanks. 

Mike Wilday

You can create a sum for each industry using sumifs. The formula below will sum the dollar amounts where the industry name is set to Distribution. 

=Sumifs([Range to sum column name]:[Range to Sum Column name], [Industry column name]:[Industry column name], "Distribution")

If you want to string it together into a single line, you can do the following

="Distribution, " + =Sumifs([Range to sum column name]:[Range to Sum Column name], [Industry column name]:[Industry column name], "Distribution") + ", Other, " + =Sumifs([Range to sum column name]:[Range to Sum Column name], [Industry column name]:[Industry column name], "Other")

And you will get a single cell with all of the data in a single line, comma separated.