When you have an excel workbook with detailed records on one spreadsheet and a summary on the second spreadsheet, it is important to make sure that the summary subtotals equal the detail subtotals.
Similarly, it is important if you have a target total and a bunch of items that are supposed to add up to something near that total, make sure you sum the items and compare the total with the target.
__________________
Light a man a fire, and he will be warm while it burns.
Set a man on fire, and he will be warm for the rest of his life.
|