Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate total stock value in Excel and Google Sheets
Excel & Google Sheets
=B2*C2✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Item | Quantity | Unit Cost | Line Value |
| SKU-001 | 100 | 5.50 | |
| SKU-002 | 250 | 2.00 | |
| SKU-003 | 80 | 12.00 | |
| SKU-004 | 50 | 8.75 |
=B2*C2→550
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Set up columns: Item, Quantity (B), Unit Cost (C), Line Value (D).
- 2In D2, enter =B2*C2 to get the value for each line item, and copy it down.
- 3In a summary cell, enter =SUMPRODUCT(B2:B6,C2:C6) to get the total stock value in one formula without a helper column.
- 4Format the value columns as currency.
Tips
- Use =SUMPRODUCT(B2:B6,C2:C6) directly when you don't need individual line values — it's more concise for totals.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Should I use average cost or last purchase cost?
It depends on your accounting method. FIFO, LIFO, and weighted average cost methods each value stock differently. Use the cost figure your business uses for inventory accounting.
How do I calculate stock value for a specific category?
Use =SUMPRODUCT((A2:A6="Category")*B2:B6*C2:C6) where A contains category labels.