Skip to content

Module 02 · Lesson 06

Formulas that do the work

Formulas point at cells, not numbers.

Excel tools7 min
FormulaWhat it does
=C5*D5Multiply: Quantity × Unit Price = Total
=SUM(E5:E219)Add a whole column (shortcut Alt+=)
=AVERAGE(D5:D219)Average unit price
=COUNTA(B5:B219)How many items are listed
=COUNTIF(B5:B219,B5)How many times an item appears (finds duplicates)
=IF(C5="","",C5*D5)Show a total only when there is a quantity
=$H$1*C5$ locks a cell: press F4 to add the $ signs