Data from another sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1742822%22%20slang%3D%22en-US%22%3EData%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742822%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I%20am%20trying%20to%20write%20a%20formula%2C%20but%20I%20need%20to%20use%20data%20from%20another%20sheet.%20How%20can%20I%20use%20that%20data%20from%20the%20other%20sheet%20in%20a%20formula%20on%20a%20different%20sheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1742822%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742906%22%20slang%3D%22en-US%22%3ERE%3A%20Data%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742906%22%20slang%3D%22en-US%22%3EYou%20can%20include%20the%20sheet%20name%20in%20the%20range%20reference%20(if%20there%20are%20spaces%20in%20the%20sheet%20name%20then%20you%20need%20a%20single%20apostrophe%20'%20around%20the%20sheet%20name)%3A%20%3DSum('Some%20Other%20Sheet'!A1%3AA10)%20But%2C%20as%20you%20are%20entering%20the%20formula%2C%20you%20can%20click%20on%20the%20other%20worksheet%20and%20select%20the%20range%20and%20let%20excel%20do%20the%20work.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello! I am trying to write a formula, but I need to use data from another sheet. How can I use that data from the other sheet in a formula on a different sheet?

2 Replies
You can include the sheet name in the range reference (if there are spaces in the sheet name then you need a single apostrophe ' around the sheet name): =Sum('Some Other Sheet'!A1:A10) But, as you are entering the formula, you can click on the other worksheet and select the range and let excel do the work.

@cheverin 

With the permission of everyone involved. Here is a file to supplement the very good explanation by Mr.Jeff Blakley (@JMB17)