Are You Making Any Money? Profit is what you make after you pay for the costs. In our example, the equation is: =D2-B2. 3. Try This: Calculate the Profit Select Cell E1 and type the label: Profit. Select Cell E2 and enter the equation: =D2-B2   Copy and paste that equation into Cells E3 through E5. 4. Add This, Too: Sum up the Profit Select Cell E6. Go to AutoSum.   What Do You See? For each fruit basket that you sell, there is a profit of $4.25.

Home -> Editing ->AutoSum

Exam 77-882: Microsoft Excel 2010 Core 5. Applying Formulas and Functions 5.3. Apply cell references in formulas: Relative