Excel totaling

Copper Contributor
Hi! My husband is having difficulty remembering how to total three cells as in a cost for material, the next cell being the cost of labor, and the next cell being what was made on a job. So he needs labor and material added and then subtracted from what the job cost and what was made in a new sell.
1 Reply

@Kristen1990 Here's a very simple example.

 

          A               B               C              D              E

1JobJob QuoteMaterialLabourProfit from Job
2Picnic Bench25078.2510071.75

                                                                   =SUM(B2-(C2+D2)) <--- formula in E2