Below is a simple table of data.
Simply select from A3 to F9 and then press the Alt key and the Equal sign.
Alt+=
This will automatically total Column F and Row 9.
It is pretty flexible - I get the same result if I select A4 to F9 or B4 to F9.
Have a great weekend.
If you are looking for more great tips check out my Tools and Tips CPE course for Accountants.
http://www.cpaselfstudy.com/item_115/Excel-Tools-Tips-for-the-Accountant.htm
