» 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:
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Positioning: The Battle for Your Mind
- Seven Habits Of Highly Effective People
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Keys to Reading an Annual Report (Barron's Business Keys)
- A Mathematician Plays the Stock Market
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?