Excel: It All Adds Up Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

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. Calculate the Profit

Select cell E1 and type the label: Profit. Click on cell E2 and enter the equation:

=D2-B2

 

Copy and paste that equation into Cells E3 through E5.

4. Sum up the Profit

Select Cell E6

Select AutoSum

 

For each fruit basket that we sell, there is a profit of $4.25.