Administration and Executive AssistantTier 115 minbeginner

Stock Value: Quantity Times Cost

Value the stock on the shelves with one formula filled down and a total that adds up.

What you will learn

• Multiply quantity by unit cost and fill the formula down
• Treat an empty quantity as out of stock (zero)
• Total the line values, and check it with SUMPRODUCT

Excel skills

Multiplication, fill down, SUM, SUMPRODUCT · Totals by Formula

The task

Month-end. Finance wants the value of what is on our shelves. The Stock tab has the quantity on hand and the unit cost for every item. Put the stock value in column E (quantity times unit cost), one formula filled down, and the total stock value on the Summary tab.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free