Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum by different sorts
I have a simple spreadsheet. While working on it I constantly need to
sort by different columns and I have several macros to do just that. The problem: For the various sorts I also need to sum the columns by their respective categories. Hear is a simple representation of what I am trying to do. Item Type Qty ---------------------------- Apple Fruit 4 Pear Fruit 10 Apple Fruit 4 Potato Veg 6 Fish Meat 22 Ex: When I sort by "Item" I want the sum for each one of the following: Apples, Pears, Potatoes, and Fish. When I sort by "Type" I want the sum for each one of the following: Fruit Veg Meat. Currently after each sort, I manually insert a row between each category and use the Sum function to get what I want. But when I sort by something else, and then come back to a previous sort the sum rows I inserted are no longer in the correct place. (They end up at the bottom.) There has got to be a better way. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotals and sorts | Excel Discussion (Misc queries) | |||
Drop Down Box that sorts | Excel Discussion (Misc queries) | |||
Sorts | Excel Worksheet Functions | |||
A question of sorts | Excel Discussion (Misc queries) | |||
Monotype Sorts in XP | Setting up and Configuration of Excel |