» 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:
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Writing Excel Macros with VBA, 2nd Edition
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Keys to Reading an Annual Report (Barron's Business Keys)
- The One Page Business Plan: Start With a Vision, Build a Company!
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
No comments have been submitted.
