Subtotal function is not working correctly

B

Bryan

I recently got a new computer at wortk with Excel 2003. My previous computer
had an older version, and the subtotal function worked fine. Here's my
problem. A report that I work on needs to be sorted 3 different ways, first
by branch office, Billing Type, then System Type. I then subtotal by branch
as my first level. Then I subtotal by Billing Type, in which I uncheck the
replace current subtotals. I then do the same thing with the Sytem Type.
The first level always works fine. Once I get to Billing Type, it starts
screwing up. It seems that if there is a blank cell in the mix, or
something out of the ordinary, it messes up my subtotalling. Any ideas on
how to correct this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top