Help Summarizing Data Based on Multiple Factors

Copper Contributor

I am trying to create a consolidated summary of some data I'm working on for a vendor.  I have a list of individuals that includes columns for their ID number, company, state, class, and what their total $ is for the current year.


I need a summary for each company that subtotals how many employees are in each state, then how many of each class type are in that state, and then the total dollar amount for each class type in that state.


My list includes about 100 companies, many of which are in multiple states, so manually filtering and totaling the data would take forever.


Any assistance is greatly appreciated!

1 Reply


That sounds like a job for a pivot table - see Create a Pivot Table in Excel