Hello d/c,

If "the total of the revenue section is the same total of the consolidated statement", how can they not be agreeing? Agreeing to what?

Are you saying that the total of a column is different when the sheet is expanded than when it is collapsed? This is almost always caused by a SUM() function including hidden rows on the expanded sheet. Don't use SUM() on your column totals when a sheet expands and collapses. Use A+B+C+D+E+F..., a formula that can be easily generated with the AutoSum button.