software

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: www.excelforum.com/member.php...oamp;userid=30381
View this thread: www.excelforum.com/showthread...hreadid=503188Use Data, Sort instead of the button

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

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

quot;LACAquot; gt; wrote in message
...
gt;
gt; I have a worksheet of raw data that needs to be sorted and summarized.
gt;
gt; Column A contains the department code: A, B, C, or D
gt; Column B contains the account code: 100, 200, 300, 400, or 500
gt; Column C contains the dollar amount for each
gt;
gt; I need to sort the data twice: Once to group all dept. codes, and then
gt; further to group all the account codes within that department.
gt;
gt; For example, for department A -- I need to summarize the total dollar
gt; amount for account code 100, then for account code 200, and so on.
gt;
gt; I need to do the same for each of the departments A through D.
gt;
gt; The SUMIF formula is what I think I need, but how do you sort twice?
gt; I can sort the data to total the dollar amounts by Department or by
gt; account Code, but I need to sort by both simultaneously.
gt;
gt; Thanks
gt;
gt;
gt; --
gt; LACA
gt; ------------------------------------------------------------------------
gt; LACA's Profile: www.excelforum.com/member.php...oamp;userid=30381
gt; View this thread: www.excelforum.com/showthread...hreadid=503188
gt;