Formulas

3 stepsWatch it once, then it is yours: click into the grid at any point to take over.Type =SUM(D1:D5) in the empty total and press Enter: the five line totals are added up.Change the desk lamps from 20 to 35: their line total and the order’s total recalculate at once.Your turn. Change a quantity or a price, or write your own formula, such as =AVERAGE(C1:C5).Watch it once, then it is yours: click into the grid at any point to take over.