Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal function is not working correctly
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Function not working | Excel Worksheet Functions | |||
Subtotal function | Excel Worksheet Functions | |||
subtotal function | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |