ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   subtotals (https://www.excelbanter.com/excel-discussion-misc-queries/28514-subtotals.html)

tkaplan

subtotals
 

I am having a problem with subtotaling in excel 2003.

i have a page with about 60 families, each having a few kids. i want to
subtotal by family the total amount.
so when i do data subtotal, by family, sum amount it takes a very long
time to subtotal - it actually does one family at a time.
the status bar says inserting subtotals then it calculates, and then
the subtotal for one family shows then it does the same thing for every
family.

in differnet versions that i have worked on it just went really quickly
- subtotaled everyone at the same time.

anyone know what is going on???


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=375202



All times are GMT +1. The time now is 10:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com