» 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:
- Wall Street Journal Guide to Understanding Money and Investing
- Advanced modelling in finance using Excel and VBA
- Accounting the Easy Way
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
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?