EXCEL studs: Question regarding subtotals inside

[LakerGod]

This question may not make sense because i'm fairly new with this function, but i'll give it my best shot.

I used the subtotal function to create grand totals for one category and then i wanted to create subtotals within that same category. My problem is, once i do this my grand total gets bumped by the very last subtotal which replaces the grand total. Therefore, my "grand total? turns out to be a subtotal and the label for my last subtotal becomes the grand total.

I really apologize if this made no sense and I hope somebody can decipher this and help me out. Thanks!

 

[Yossarian]

no it makes no sense at all. post the file somewhere.

 

[Subterranean Homesick Alien]

Yossarian is right, your explanation is hard to grasp. But if I were to guess at what you are trying to do, you are saying you want subtotals from several catagories to be added together in a grand total? If so, it would go something like this:

catagory 1 subtotal: =SUM(B5:B8) <adds cells b5 through b8>

catagory 2 subtotal: =SUM(B11:B17) <adds cells b11 through b17>

Grand Total: =SUM(B9,B18) <adds cells b9 and b18 together which are the subtotals of catagories 1 and 2>

 

[LakerGod]

Thanks to those of you who tried to help.


I guess other people had a similar problem...


Here is the link to the problem.


Here is the link to the fix.