Hello d/c,

OK - one senrtence at a time...

It is not the exact case you are describing, but somewhat similar.

So, the totals at the bottom of a column do not add up to the sum of all the numbers displayed above when a statement is expanded? Check (carefully) for hidden rows being included in the sum when the sheet is expanded.

Where is the autosum function??

On the format toolbar. View | Customize | Toolbars | Reset the format toolbar to make sure the Sigma (Sum) button is displayed. To use the button do the following:

• Collapse the sheet.
• Select the cell to receive the sum.
• Click the Autosum button.
• Ctrl-click or shift-click to select the cells you want to add together.
• Click the Autosum button again.

The formulas have been changed, but it still seems to be occurring.

What still seems to be occurring?

What is essentially happening is that every subtotal from the consolidated statement eg. Revenue is the same as the subtotal for Revenue on the departmental statements, which is not the case, but the funny thing is that the individual line totals are correct, they just don;t add up to anywhere near what the subtotals show.

Sorry, this makes no sense. The first part says the numbers are the same between the statements and "the individual line totals are correct", then they "don't add up". To what?

I hope that makes sense.

Not yet. Sorry.