[mso] Excel 2003 Subtotal Question

  • From: "McDonald, Christine, Ms, DCAA" <Christine.McDonald@xxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Tue, 1 Mar 2005 16:03:56 -0600

Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: 7bit
Has anyone run across a problem using subtotals in Excel 2003?  I'm having
an office report that when subtotaling on a field, if there are rows where
the field is blank, those rows get included in the subtotal for the last
field with data.  So if I subtotal on the Prog Code field and the last
rows with data are for prog code WA, the blanks are included in the WA
subtotal.  This does not happened with the same file used in Excel 2002.
I checked the knowledge base but couldn't find anything, but I was having
trouble trying to figure out exactly what to search for.

Thanks,

Christine McDonald, CPA
Technical Specialist
Western Regional Office
Information Technology Division




-- Binary/unsupported file stripped by Ecartis --
-- Type: application/x-pkcs7-signature
-- File: smime.p7s


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts:

  • » [mso] Excel 2003 Subtotal Question