Module 02 · Lesson 06
Formulas that do the work
Formulas point at cells, not numbers.
Excel tools7 min
| Formula | What it does |
|---|---|
| =C5*D5 | Multiply: 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 |