SOLVED

Master Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2229979%22%20slang%3D%22en-US%22%3EMaster%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2229979%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can't%20get%20my%20Master%20Sheet%20to%20total%20my%20worksheet%20pages%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2229979%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-2230092%22%20slang%3D%22en-US%22%3ERe%3A%20Master%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2230092%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1006113%22%20target%3D%22_blank%22%3E%40PMcD0609%3C%2FA%3E%26nbsp%3BWould%20be%20helpful%20if%20you%20could%20say%20a%20little%20bit%20more%20about%20what%20you%20are%20trying%20to%20do.%20Perhaps%20share%20the%20workbook%2C%20indicating%20what%20you%20want%20totalled.%20Beware%20to%20remove%2Freplace%20any%20private%20and%2For%20confidential%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I can't get my Master Sheet to total my worksheet pages 

8 Replies

@PMcD0609 Would be helpful if you could say a little bit more about what you are trying to do. Perhaps share the workbook, indicating what you want totalled. Beware to remove/replace any private and/or confidential information.

@Riny_van_Eekelen 

 

The worksheet includes 10 sheets.  I did the =SUM and clicked on each cell I need added together on the Master sheet.  The information carries over to the Master but it won't add the columns.  I don't see on here where I can attach my worksheet.  

 

PRICING WORKSHEET WORKSHEET TOTAL $ WORKSHEET TOTAL HRS WORKSHEET TOTAL DAYS

ALUMINUM FENCE $- 0.00 0.00
CAST LIGHTING $- 0.00 0.00
CAST SITTING WALL DOUBLE SIDED $- 0.00 0.00
CAST WALL SINGLE SIDED $- 0.00 0.00
DIAMOND PRO WALL $- 0.00 0.00
DRAINAGE $- 0.00 0.00
FIRE PITS $- 0.00 0.00
IRRIGATION $- 0.00 0.00
PAVERS & STEPPERS $- 0.00 0.00
PLANTING $- 0.00 0.00
POST PROTECTORS $- 0.00 0.00
PRE-ENGINEERED FRENCH DRAIN SYSTEM $- 0.00 0.00
QUARRY STEPS $- 0.00 0.00
ROCKS & CURBSTONES $- 0.00 0.00
SOD & SEED $- 0.00 0.00
STRAW MATTING $- 0.00 0.00
HORSE BOARD FENCING $- 0.00 0.00

PROJECT TOTAL #NAME? 0.00 0.00


@PMcD0609 When you reply you'll see the "Drag and drop ...... " section below. Press "browse", find the file and upload.

Screenshot 2021-03-23 at 16.59.23.png

best response confirmed by PMcD0609 (Occasional Contributor)
Solution

@PMcD0609 Your sheet contains circular references. Cells that contain formulae that include the cell where the formula is written. Go to the "Formulas" ribbon, Error checking and then "Circular References" until you have corrected all of them. Did that for you in the attached sheet, but everything still comes out to zero as it seems that all of your cells in the master sheet link to cells with zero values. But perhaps I'm not following the logic of your schedules.

Thank you so very much!!!!! I have been racking my brain (which is getting older by the minute).
You are the best. I will do my best to pay it forward today and make someone's day easier!!!

@PMcD0609 Glad it worked out for you!