Subtotal Function

[schielrn]

I thought this may be a good place for this. I came across a co-workers spreadsheet and they had it set up where they were doing subtotals of a column, but for some reason were also using subtotals for the row totals, but were never hiding or unhiding the rows. BUT the weird thing I noticed is that the subtotal did not work on rows that had subtotals in them as well (See G1 for the total of that column?)

Can anyone explain why this phenomenon is happening? It seemed really strange to me.

Well it appears that HTML is off in this forum, so I guess it will have to go in the main forum here:

http://www.mrexcel.com/forum/showthread.php?p=2762335#post2762335