Excel totaling

%3CLINGO-SUB%20id%3D%22lingo-sub-2514560%22%20slang%3D%22en-US%22%3EExcel%20totaling%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2514560%22%20slang%3D%22en-US%22%3EHi!%20My%20husband%20is%20having%20difficulty%20remembering%20how%20to%20total%20three%20cells%20as%20in%20a%20cost%20for%20material%2C%20the%20next%20cell%20being%20the%20cost%20of%20labor%2C%20and%20the%20next%20cell%20being%20what%20was%20made%20on%20a%20job.%20So%20he%20needs%20labor%20and%20material%20added%20and%20then%20subtracted%20from%20what%20the%20job%20cost%20and%20what%20was%20made%20in%20a%20new%20sell.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2514560%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2514624%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20totaling%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2514624%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1095352%22%20target%3D%22_blank%22%3E%40Kristen1990%3C%2FA%3E%26nbsp%3BHere's%20a%20very%20simple%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BB%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BC%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20D%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20E%3C%2FP%3E%3CTABLE%20width%3D%22390px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2240px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2254.0455px%22%3EJob%3C%2FTD%3E%3CTD%20width%3D%2266.7841px%22%3EJob%20Quote%3C%2FTD%3E%3CTD%20width%3D%2274.8864px%22%3EMaterial%3C%2FTD%3E%3CTD%20width%3D%2260.0795px%22%3ELabour%3C%2FTD%3E%3CTD%20width%3D%2293.2045px%22%3EProfit%20from%20Job%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2240px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2254.0455px%22%3EPicnic%20Bench%3C%2FTD%3E%3CTD%20width%3D%2266.7841px%22%3E250%3C%2FTD%3E%3CTD%20width%3D%2274.8864px%22%3E78.25%3C%2FTD%3E%3CTD%20width%3D%2260.0795px%22%3E100%3C%2FTD%3E%3CTD%20width%3D%2293.2045px%22%3E71.75%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3DSUM(B2-(C2%2BD2))%20%26lt%3B---%20formula%20in%20E2%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor
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