Advanced data sorting in Excel 2007?

Glad your data is in separate cells as thought first of all it was in the one. To start with highlight all data but NOT the column headings then, from the Home menu click on the Sort icon which is to the right of the ribbon. (Or from Data menu, the sorting is in the middle of the ribbon. If your data werejust in the one columnyou could just click on the A-Z and it will sort everything.

However, as you have rightly got it in different columns, , click on custom sort, then sort firstly by colour and then by figures so that if you were to have, for instance, blue 60, blue 45, the blue 45 would appear before the blue 60. If you then want totals of each colour, as it is sorted, you could then do a subtotal of each category which would be easier than doing a sumif function. If you use the Data menu for sorting, then the subtotalling is in the same menu, to the right side but in this case you need to highlight the column headings as well.

Yes, but you need to do another table for that

- Create a list of unique items in another range of cells (Or sheet)

In your example:

Red

Yellow

Blue

- Paste SUMIF function in the next cell like this

=SUMIF( A:A, G1, B:B)

Assuming your long big list is in column A, the values you want to sum in column B and the unique list is in column G

- Then Fill that cell donw to cover all your values

Then do the sort for this new table G and H

Good luck

VBAXLMan

That is not sorting, but summing. You can use the sumif function to sum all numbers where the color is blue.

I agree