Cross Page Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-3334439%22%20slang%3D%22en-US%22%3ECross%20Page%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3334439%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20get%20a%20total%20from%20various%20worksheets%20to%20add%20up%20in%20one%20worksheet%3F%3C%2FP%3E%3CP%3EFor%20example%20if%20I%20have%20a%20file%20with%205%20worksheets%20and%20totals%20in%20various%20columns%20in%20worksheet%201%2C%202%203%20%26amp%3B%204%2C%20how%20do%20I%20get%20all%20those%20totals%20to%20add%20up%20automatically%20in%20the%20last%20worksheet%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3334439%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3334559%22%20slang%3D%22en-US%22%3ERe%3A%20Cross%20Page%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3334559%22%20slang%3D%22en-US%22%3E%3DSUM(Sheet1!%20A14%2CSheet2!%20B17)%3C%2FLINGO-BODY%3E
Occasional Visitor

How do I get a total from various worksheets to add up in one worksheet?

For example if I have a file with 5 worksheets and totals in various columns in worksheet 1, 2 3 & 4, how do I get all those totals to add up automatically in the last worksheet ?

1 Reply
=SUM(Sheet1! A14,Sheet2! B17)