» Summing Stock Lists
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
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:
- Microsoft Excel 2002 Simply Visual
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Microsoft Office XP Introductory Concepts and Techniques
- Windows XP for Dummies
- Business Analysis with Microsoft Excel (2nd Edition)
- Flipping Properties: Generate Instant Cash Profits in Real Estate
No comments have been submitted.
