When using subtotals function, they do not come up at the bottom

G

Genta

I am using the subtotal functions in Excel 2002. I have used it before
without problems. Today it is not working properly. I have 2 issues.

Issue1
These are the steps that I normally do: do the subtotals, insert double rows
at level 2 using the visible cells only, remove the subtotals and then redo
the sub-totals again. By doing this I normally have the data rows then the
sub-total row and then two empty rows for each customer name. Today I have
the data rows then the 2 empty rows then the sub-total row.

Issue2
When I want to do a second subtotal within each customer (keeping previous
totals)I do not get sub-totals for all the sections within a customer. Some
sections do have sub-totals but some do not. Why would this be so?

Please help
 

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

Similar Threads

Calculating subtotals 22
Dealing with a Pivot Table (when I don't want to) 0
Unmatched rows 0
Footer On Last Page Only Not Working 1
Help with nested subtotals. 2
Help with reporting 1
Display Multiple Cells when Using Subtotal Function 0
Totals rows shouldn't become invisible when filtering 3

Top