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 *************************************************************