How To Create An Excel Formula Using Data From Several Worksheets

As you develop your skills using Excel you may need to create a formula to combine data from more than one worksheet. This article describes several ways to do this and summarises advantages and disadvantages of each. The ways are to use arithmetic operators such as +,-,* or /, or use a function such as SUM(range) or use consolidation.

The full article appears here:
http://www.microsofttraining.net/article-1622-create-excel-formula-using-data-from-several-worksheets.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com