 |
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
| Screenshot // Summing values in vertical and horizontal ranges in Microsoft Excel |
 |
|
|
|
|
|
|
RATING:
3.06
VIEWS:
20800 |
|
|
|
|
|
|
READER COMMENTS (view all comments)
|
Summing Hours
Liz wrote on December 31, 1969 19:00 EST |
Hi, I've created a time sheet, and have used the Military time format to SUM up my hours horizontally per day. It works great.
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?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
Business Plans For Dummies®
Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
Windows XP for Dummies
Accounting and Financial Fundamentals for Nonfinancial Executives
Yes, You Can Time the Market!
Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
|
|
|
|
