» Summing Stock Lists
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
To total a stock list, use an Array Formula or SUMPRODUCT Formula:Use Array Formula:
1. Define Names to both the Quantity (B2:B10) and Price ranges (C2:C10). (To define a range Name, see Tip #188.)
2. Type the formula =SUM(Quantity*Price) into a cell.
3. To change the formula to an Array Formula (see Tip #201), press F2 and simultaneously press Ctrl+Shift+Enter.
Use SUMPRODUCT Formula:
1. Inset SUMPRODUCT function into cell D15.
2. Paste to the first argument box (Value1) the Name Quantity and paste to the second argument box (Value2) the Name Price and press OK.
Book Store:
Recommended Books:
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Special Edition Using Microsoft Office XP
- Guide to Financial Reporting and Analysis
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Understanding Financial Statements
- Windows XP All-in-One Desk Reference For Dummies
No comments have been submitted.
