Formuladrill

Level 5: Finance Exercise 93 of 118

Average price paid

An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Stock was bought in four lots at different prices. Work out the average price paid per unit in C6, weighting each price by the units bought at that price.

What this exercise teaches

AVERAGE(C2:C5) treats a lot of 80 units the same as a lot of 500. A weighted average multiplies each price by its units first, then divides by the total units.

A hint if you get stuck

Total cost divided by total units. SUMPRODUCT(B2:B5,C2:C5) is the total cost.

Functions used: SUM, SUMPRODUCT

Try it now, free, no account needed

Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Finance