#1   Report Post  
tkaplan
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel gets subtotals out of order using multiple sorts and subtot. jeffl Excel Discussion (Misc queries) 1 March 29th 05 01:35 AM
Subtotals Joan Excel Discussion (Misc queries) 1 March 2nd 05 10:33 PM
Subtotals Problem when Filtering Brenda Rueter Excel Discussion (Misc queries) 2 February 15th 05 09:05 PM
In Excel, how do you copy and paste just the subtotals into anoth. mmiazga Excel Discussion (Misc queries) 4 February 13th 05 01:17 AM
why are nested subtotals coming out below outer subtotals? Hendy Excel Worksheet Functions 2 January 18th 05 08:09 PM


All times are GMT +1. The time now is 08:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"