» Sum total stock value for any part in Microsoft Excel
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
Data in Cells A1:C10
| A | B | C | |
| 1 | Parts | Quantity | Price |
| 2 | A880Q | 345 | 15.00 |
| 3 | B901V | 205 | 12.00 |
| 4 | C666R | 257 | 13.00 |
| 5 | A880Q | 413 | 18.00 |
| 6 | C666R | 413 | 18.00 |
| 7 | A880Q | 517 | 20.00 |
| 8 | B901V | 621 | 22.00 |
| 9 | C666R | 673 | 23.00 |
| 10 | A880Q | 725 | 24.00 |
Part # in cell E2: A880Q
Formula in cell F2:{=SUM(IF(Parts=E2,Price*Quantity,0))}
Result: 40,349
| List of Define Names | |
| Parts | =Sheet1!$A$2:$A$10 |
| Price | =Sheet1!$C$2:$C$10 |
| Quantity | =Sheet1!$B$2:$B$10 |
Please note:
The formula is an Array Formula, after entering the formula in the cell, press F2 and than press Ctrl+Shift+Enter.
Book Store:
Recommended Books:
- Analysis of Financial Statements
- Financial Modeling - 2nd Edition
- Special Edition Using Microsoft Excel 2002
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
No comments have been submitted.
