You can copy this formula to cells D11-H11 to complete your change calculations. Each formula in Row 11 is the result of subtraction using the “-” (hyphen) as a minus sign. Row 11 shows the change from the prior month.
Row 9 displays the total of sales for all cities.Īre the sales increasing each month? If so, by how much? In this example, columns C through H show the sales for each month. Unfortunately, Excel doesn’t have a SUBTRACT formula.
You need to subtract the prior month’s sales from the current month’s sales. Your boss asks you to add a row that shows the change from the prior month. You have created a report that shows your company’s sales by month.
