» 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:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Writing Excel Macros with VBA, 2nd Edition
- Positioning: The Battle for Your Mind
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Microsoft Office XP Step-By-Step (With CD-ROM)
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
No comments have been submitted.
