Sometimes you need to check your formulas to see what they are adding. There are a few ways to audit your formulas.
The first method is to simply click “F2″ in the cell with the formula that you want to audit - this will highlight and color code the cells that are being added:
Or you can click Tools> Formula Auditing > Trace Dependents
This will add a dot to each cell that is used to create the formula
The second method can be used to trace dependents accross multiple worksheets. In this case an arrow will appear displaying the worksheet icon.
1. Double-click the arrow.
2. In the Go to box, click the reference to view the dependent cell.
If you liked my post, feel free to subscribe to my rss feeds
Any advice given on this blog is my own opinion and not that of anybody else. That said - any advice taken from this blog is at your own risk. 
BlogoSquare