Double Sorting of Data
 

I have a worksheet of raw data that needs to be sorted and summarized.

Column A contains the department code: A, B, C, or D
Column B contains the account code: 100, 200, 300, 400, or 500
Column C contains the dollar amount for each

I need to sort the data twice: Once to group all dept. codes, and then
further to group all the account codes within that department.

For example, for department A -- I need to summarize the total dollar
amount for account code 100, then for account code 200, and so on.

I need to do the same for each of the departments A through D.

The SUMIF formula is what I think I need, but how do you sort twice?
I can sort the data to total the dollar amounts by Department or by
account Code, but I need to sort by both simultaneously.

Thanks


--
LACA
------------------------------------------------------------------------
LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381
View this thread: http://www.excelforum.com/showthread...hreadid=503188

Double Sorting of Data
 

Use Data, Sort instead of the button

for more information on sorting see
http://www.mvps.org/dmcritchie/excel/sorting.htm

for information on searching Excel newsgroups see
http://www.mvps.org/dmcritchie/excel/xlnews.htm
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"LACA" wrote in message
...

I have a worksheet of raw data that needs to be sorted and summarized.

Column A contains the department code: A, B, C, or D
Column B contains the account code: 100, 200, 300, 400, or 500
Column C contains the dollar amount for each

I need to sort the data twice: Once to group all dept. codes, and then
further to group all the account codes within that department.

For example, for department A -- I need to summarize the total dollar
amount for account code 100, then for account code 200, and so on.

I need to do the same for each of the departments A through D.

The SUMIF formula is what I think I need, but how do you sort twice?
I can sort the data to total the dollar amounts by Department or by
account Code, but I need to sort by both simultaneously.

Thanks


--
LACA
------------------------------------------------------------------------
LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381
View this thread: http://www.excelforum.com/showthread...hreadid=503188