referring to other sheets in a workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2037708%22%20slang%3D%22en-US%22%3Ereferring%20to%20other%20sheets%20in%20a%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2037708%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20create%20a%20link%20to%20a%20SUM%20of%20formula%20on%20a%20subsequent%20sheet%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2037708%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-2037754%22%20slang%3D%22en-US%22%3ERe%3A%20referring%20to%20other%20sheets%20in%20a%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2037754%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F920318%22%20target%3D%22_blank%22%3E%40KJONES1110%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Euse%20the%20sheet%20name%20before%20the%20cells%20name%20and%20add%3CSTRONG%3E%20!%3C%2FSTRONG%3E%20after%20the%20sheet%20name%2C%3CBR%20%2F%3E%3DSUM(Sheet1%3CSTRONG%3E!%3C%2FSTRONG%3EA1%3AA4)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20If%20my%20post%20helped%20you%2C%20please%20click%20on%20like.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How can I create a link to a SUM of formula on a subsequent sheet

1 Reply

Hi @KJONES1110 

 

use the sheet name before the cells name and add ! after the sheet name,
=SUM(Sheet1!A1:A4)

 

 

* If my post helped you, please click on like.