Problem with subtotal function

I've noticed since changing to Excel 2003 that when I have a spreadsheet that 
I want to do multiple subtotals on that if I have one grouping within a group 
followed by multiple groupings within a group that my subtotals start 
aligning in such a way that it is very confusing to read.  Has anyone run 
across this and know of any fix?

For example, I have sorted a spreadsheet with names, locations & other data 
by names, then location then subtotaled by name then by location.  My results 
Location 1 subtotal
Location 2 subtotal
Name 1 subtotal
Location 1subtotal
Location 2 subtotal
Name 2 subtotal
Name 3 subtotal
Location 1 subtotal of Name 3
Location 1 subtotal
Location 2 subtotal
Name 4 subtotal
Location 3 subtotal of Name 4
Location 1 subtotal

So when Name 3 only had one location it started throwing the subtotals out 
of alignment.

3/17/2010 5:57:01 PM
excel.worksheet.functions 4936 articles. 2 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 20


Similar Artilces:

Pivot tables problem
i just created a pivot table and he first row shows an empty row then the second showed data in it why so any help. Your source data has some blanks in it -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Amin" wrote: > i just created a pivot table and he first row shows an empty row then the > second showed data in it why so any help. ...

Dual Boot problem after latest Windows update
I dual boot Win XP Pro SP3 with Win 7 RC1. Had no problems until yesterday 2-9-10. I downloaded the malitious software removal tool which went OK. I went back and downloaded the first 5 items in the list. I don't like to download to many at one time. Since a reboot was required I did that. I chose early version of Windows from boot up menu and was taken to safe mode screen. Chose normal startup, Win XP startup screen briefly appears and then reboots. If I choose Win7 from boot menu, Win 7 starts normally. No matter what I try to get into Win XP it goes into reboot and Safe Mo...

CComboBox Assert Problem
I have read the MSDN documentation and the Programming Windows 5th Edition, but cannot figure out how to resolve this. The parent creates the dialog and attempts to add CStrings to the combobox control: SaveAsXfileDLG SX(this); int numMeshes = g_MeshContainer->GetNumMeshes(); for (int i = 0; i < numMeshes; i++) { pStrmesh = g_MeshContainer->GetMeshName(i); if (!SX.AddNameToList(pStrmesh)) { SX.EndDialog(IDCANCEL); return; } } In the combobox class I have this: BOOL SaveAsXfileDLG::AddNameToList(CString* Cname) { static int ItemIndex = 0; CCom...

Problem Reading Reminders
Each time I boot up I get the following message, "There was a problem reading one or more of your reminders. Some reminders may not appear. Cannot locate recurrence information for the appointment." I thought at first that if there was only a problem with one, I could wait and eventually it would be archived and no longer appear. But it has given me that message for Months now. Any suggestions as to what to do? Rob Monroe ...

Problem using two timezones
I'm having a problem with Outlook 2003, trying to use two time zones. The time display for both zones is correct when I initially set up the two zones; but if I swap the time zones, the first zone displays an hour less than it should. If I swap back, they're correct. What's going on and how do I fix it? does the second zone have the correct daylight time setting? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Need Help with Common Tasks? O...

Exchange 2003 Problem after Windows 2003 SP Installation
Hi! We have Exchange 2003 (front-end and back-end). After we have installed Windows 2003 SP1 on servers we cannot create Mail-Enabled-Group in Exchange. We get error message: "Unspecified error" code="0x80004005" execut eSeqNo="28" How can we fix this problem? Best Regards Cicek ...

worksheet functions #2
In microsoft Excel 2003: Does anyone know of a worksheet function, built in or homemade, that can replace the contents of a cell when it becomes inactive? I would like to enter a "b" or an "s" into a cell and have it changed to "Buy" or "Sell" or any other replacement string as soon as I go on to another cell. Can this be done? Thanks. Les, A function could do it, but would have to live in a different cell from that containing the B or S. You could use Tools - Autocorrect to cause it to replace B with Buy, etc., after it's been keyed in...

Outlook Web Access Problem
Hi All, Heres short version of my recent post. On accessing my Exchange Server Outloook Web Access from internet through a firewall from Windows 2000 client, I am unable to login and after 3 tries get "Error: Access is denied". Please refer to my recent post with subject for explanation to question "OWA Access Is Denied for Win2k Users on internet" Thank You, rawCoder Havent seen the other posts, but this is always a good place to start: E200x:;en-us;326303 5.5:;en...

Recently Used File List Problem
I have Excel 2000. I have the recently used file list set to 6. During a session of Excel, it will expand from, say, 4 files to 5 (when I click on File/Open), but after I close Excel and relaunch it, it loses the last file opened and only shows 4. This seems to happen ONLY with spreadsheets from a particular folder. Others stay across sessions. What happened, and what can I do to get it back to working properly between sessions? Thanks. ...

Thorny problem graphing XAxis dates
Sorry, I'm not really sure how to state this question succinctly. I have data in an MSAccess Db re medications and the time\date and amounts taken. Mads are entered only in the db on days when they are taken yet I need the graph to show ALL days including days not taken. That is, days when the amount is inferred to be zero because no data appears for that day. Sorry, that's probably as clear as mud. Currently, I'm using VBA code to select the data, build a spreadsheet and then build a graph from the spreadsheet I built. The problem is that it (obviously) graphs only the days meds...

Eseutil problems
Hi there. Im having some trouble with eseutil . My exchange is down coz of inconsistent data but after i do an intergrity check and a repair , it start working. but i cannot open attachements. If i try to do a defrag , i get several error messages like , "Illegal duplicate" key for the first time and "bad signature for a log file " in the second attempt. somebody pls assist with some tips. Rgds You also need to run "isinteg -s <servername> -fix -test alltests Run that over and over until you get 0 errors, 0 fixes. The syntax is the same with 5.5 sans t...

Plotting Problems
I'm using Excel 2002 on an NT 4.0 system. When I copy numbers from an older version of Excel(95 or 97?), the numbers pasted are incorrect. Any ideas on why this is happening and ways to fix it? Thanks in advance, -- Wes Incorrect as in........? Insert your description here. Gord Dibben Excel MVP On Tue, 19 Oct 2004 13:39:05 -0700, Wes <> wrote: >I'm using Excel 2002 on an NT 4.0 system. When I copy numbers from an older >version of Excel(95 or 97?), the numbers pasted are incorrect. Any ideas on >why this is happening and way...

UNICODE problem #2
I am trying to port my dll to UNICODE. So I have defined _UNICODE instead of _MBCS, after compiler complained that he could not find mfc42u.lib and mfcs42u.lib. I copied these two dll (from my Visual Studio 6 CD) into the \MFC\lib. And now when I compile I have the following message : msvcrt.lib(crtexew.obj) : error LNK2001: unresolved external symbol _WinMain@16 Although I think it's stupid (since I am building a dll and not a .exe) I tried to put wWinMainCRTStartup in link/output and it compiles. The problem is everytime I call an exported function of the dll, it crashes. Please Help ...

Fundamental Problem With CDs
I must be doing something fundamentally wrong with the way I work with my CDs in Money 2005, and I'd appreciate some advice. I opened a one month CD a couple of years ago and I have just let the bank renew it automatically. When I enter the renewal information from the bank, Money requires me to "redeem" the CD, then "buy" a new CD. This is counter-intuitive since the bank uses the same account number. For example, I have to "redeem" CD Account 123 and "buy" a new CD Account 123 #2. Then a month later I "redeem" CD Account 123 #2 and...

Report website problems here
I reported the problem last week of the email not working properly. I was asked to send mycomments to the website below using the case number SRX1110134208ID. I recommend alld user to respond to this case number with their comments. I think it is silly that Microsfot doesn't maintain their own website properly and it take almost 2 weeks to fix problems that effect thousand of customers.;en;1389&WS=managermail Were you having email problems with Publisher? -- Mary Sauer "Joel"...

Attachment Blocking Problem
Hi, We want to be able to block certain attachment types for our OWA users, (i.e. exe, bat, cmd etc) as these can harbour viruses. The reason for this, is that between our Exchange Front End Server and the client on the Internet we use an SSL encrypted tunnel (bridged by ISA Server Std 2004) in the middle and we are unable to scan inside the tunnel for viruses. We have implemented the recommended solution, as per knowledgebase article 830827, the Microsoft Exchange 2003 Client Access guide and the technet article at the following URL:

Date Functionality
So i want to add dates in Excel i want to say.. this is this month; next month is I would normally use DateAdd function.. or dateserial-- or something.. but these aren't working for me in Excel; it just gives me this annoying '#ERROR' bullshit i mean-- aren't these standard functions? wrote... >So i want to add dates in Excel > >i want to say.. this is this month; next month is > >I would normally use DateAdd function.. or dateserial-- or something.. > >but these aren't working for me in Excel; it just gives me this >annoy...

Multivalued Field Functionality in Access 2003
Hello All, I am in a bit of a dilemma. I am trying to design an Access Database that quite frankly needs multivalued fields so that I can use a checked listbox, but I am limited to Access 2003 and cannot use Access 2007, in which I already have a fully working model. I am building a database with a central table, called GENERAL. There are 5 additional forms, DRUGNAME, ADDITIONALMEDICATIONS, INJURYINFORMATION, etc. Each one contains one field which has a list. For example the DrugName table would contain a list of all the prescription drugs that the person possibly could have been on. In 200...

Problems With Access 97 in Access 2002
I have an Access 97 database that I am opening in Access 2002 in “compatability” mode. What is happening is that it goes into a “loop” – the status bar shows messages over and over. Sometimes I can break out of it. I can convert it Ok, however. What’s going on? ...

Problem extending a Win32 Console App with a MFC Dialog ?
I have a multithreaded win32 console application, which I am trying to extend to open a separate dialog window based on the CDialog class (This has been built using the Visual Studio Resource Editor). I am effectively trying to add a MFC resource into a Win32 console application, but after the window opens it freezes, if other windows open over it and are moved away the widow is not redrawn. I have called AfxWinInit at the start of main, and declared my instance of the dialog within main. Any advice on where I am going wrong would be greatly appreciated. "Keith" <K...

Paint problem in dialog
I have a dialog-based app that paints in various static control after certain wait times. For starters, I did this all outside of OnPaint(). Works fine, until the app gets covered by another and uncovered. I knew I'd have to go back and fix that. So I have the existing Draw() functions I wrote that make a CClientDC. Now I modify them to allow a DC* pointer to be passed in, and call them from OnPaint() as appropriate. Problem is, nothing happens when OnPaint() calls them. It gets to the function, but no drawing results. My Draw() functions now detect if they are called from OnPaint(). ...

Offline Address Book problem
Hi All, I have users that use outlook 2003 and use the "cache" mode. The users seat on offices that connected with slow links. When they open the outlook --> new mail --> add user, and then right click user --> Outlook properties, the outlook freeze and they get message that the " server is retrieving data" from the GC The offline address book is downloading successfully. What can be the reason that the client go to the GC instead of the offline address book? Thanks In Advanced :-) Nir This sounds like a good question, but I don't understand what you mean...

Formula Bar Problem #2
I have recently reinstalled Office XP 2002 and updated to SP3. When I open Excel without the formula bar selected under 'View' everything is OK. When I select 'Formula Bar' the spreadsheet disappears (or looks like a blank very large cell with font at x00 points). I cannot get into the proper part of the spreadsheet though. I don't really want to reinstall and update again and detect and repair does not solve the problem. Is there a DLL problem? Any ideas? Richard ...

Outlook 2k-Msn/Hotmail Problem
Problem You can not get MS Outlook 2000 to send & retrieve your Msn/Hotmail email but you can with OE 6.0 at Answer: The information in this article applies to:=A0 The Microsoft Network version 6.1 & up =A0 Only accounts that were created using a "legacy" MSN client (MSN version 5.4 and earlier), can be reset to POP3 access. Accounts that never had a POP3 Inbox (accounts created using MSN Explorer) cannot be reset to POP3 e-mail, because there is no POP3 inbox to reset the account to. =A0 So there are two options for resetting or reconfiguring your e-mail acco...

Frustrating Excel to Word Copy/Paste Problem
Hi, I'm using Office 2004 and have all the updates installed. I'm having a weird, VERY frustrating problem with either/both my Excel and Word apps. In an Excel I have 2 simple column charts that are independent, but side by side in the worksheet. Whenever I select both charts and choose COPY, and then switch to Word and choose PASTE SPECIAL (Picture) only the left-hand chart will actually paste and display, but the right-hand chart does not display. Oddly, the graphic "handles" of the right-hand chart display when the chart is selected, but the actual chart itself does not sh...