Sorting and Summing by Formula

[lotstolearn99]

My question is about looking at the data in one table, and essentially creating a summary table that is sorted in a different order to create another table.

We have a worksheet with lots of data that is constantly being updated and increasing in the length of rows. We want another worksheet be the summary of the first, and sorted on three fields.

Attached is a simple example where we have raw data and what I want the results to look like in the resulting tab. In this example, we want the data sorted and summed based on the Sales Person, then Team, then Month

Is there a way to do this via formulas?

FWIW, we're using Excel 2010.

Thanks in advance,
John

[oeldere]

How about an pivot table.

See the attached file.

[lotstolearn99]

For our situation, the problem with using Pivot Tables is that we then use the resulting table to run other formulas. For example, we run vlookups, countifs, sumifs, frequency, match, etc. on that data; the last two being the main reason we need the data resorted.

[lotstolearn99]

Or, I should say I don't know how to use formulas in the "Row Label" section of a Pivot Table.

[oeldere]

Click on the pivot table.

Then you can see what I have put in the row labels.