» Summing values in vertical and horizontal ranges in Microsoft Excel
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Select the range of data, including the empty rows and columns surrounding the data A1:K11 (see screenshot).
A quick technique for selecting data without using the mouse:
select cell A1, press Shift, and select cell K11.
Now press Alt+= or click the AutoSum icon.
Result: The SUM formula is added to the end of each row and the bottom of each column.
Book Store:
Recommended Books:
- Microsoft Excel 2002 Formulas (With CD-ROM)
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- The Basics of Finance: Financial Tools for Non Financial Managers
- Marketing Plans That Work, Targeting Growth and Profitability
- The Fall of Advertising and the Rise of PR
- Financial Reporting and Analysis (2nd Edition)
My problem is, when I want to my total hours for the week, I sum those totals vertically. It doesn't seem to work! What do I have to do to make this work?