SOLVED

How do I create a formula in one sheet to + or - a number from a range of cells in another sheet?

%3CLINGO-SUB%20id%3D%22lingo-sub-3216553%22%20slang%3D%22en-US%22%3EHow%20do%20I%20create%20a%20formula%20in%20one%20sheet%20to%20%2B%20or%20-%20a%20number%20from%20a%20range%20of%20cells%20in%20another%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3216553%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sheet%20(Sheet1)%20with%20a%20cell%20that%20has%20a%20%23%20and%20I%20need%20that%20%23%20to%20decrease%20or%20increase%20based%20on%20another%20sheet%20(Sheet2)%20range%20of%20cells.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3216553%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-3216914%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20create%20a%20formula%20in%20one%20sheet%20to%20%2B%20or%20-%20a%20number%20from%20a%20range%20of%20cells%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3216914%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318573%22%20target%3D%22_blank%22%3E%40tlwarranties%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20I%20recommend%20to%20provide%20more%20information.%3C%2FP%3E%3CP%3EIf%20possible%2C%20add%20a%20file%20(without%20sensitive%20data)%20and%20use%20this%20file%20to%20describe%20your%20issue%2Fproject%20step%20by%20step%2C%20or%20add%20photos%20with%20the%20appropriate%20description.%3C%2FP%3E%3CP%3EPlease%2C%20always%20inform%20about%20your%20Excel%20version%2C%20operating%20system%2C%20storage%20medium%2Fhard%20drive%2C%20OneDrive%2C%20Sharepoint%2C%20etc.).%3C%2FP%3E%3CP%3EDon't%20forget%20that%20not%20every%20Excel%20user%20has%20a%20clue%20about%20every%20job%20and%20what%20you%20see%20he%20can't%20see.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20link%20you%20will%20find%20some%20more%20information%20about%20it%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217017%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20create%20a%20formula%20in%20one%20sheet%20to%20%2B%20or%20-%20a%20number%20from%20a%20range%20of%20cells%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217017%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3B%20I%20figured%20that%20part%20out%2C%20thanks.%26nbsp%3B%20New%20question%3A%26nbsp%3B%20how%20do%20I%20stop%20a%20value%20from%20repeating%20when%20there%20is%20nothing%20in%20one%20of%20the%20cells%20i'm%20using%20in%20the%20formula%3F%26nbsp%3B%20Is%20there%20a%20way%20to%20make%20those%20either%20zeros%20or%20just%20blank%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Untitled.png%22%20style%3D%22width%3A%20179px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351451i5D9BC492B49F8C6C%2Fimage-dimensions%2F179x291%3Fv%3Dv2%22%20width%3D%22179%22%20height%3D%22291%22%20role%3D%22button%22%20title%3D%22Untitled.png%22%20alt%3D%22Untitled.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217045%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20create%20a%20formula%20in%20one%20sheet%20to%20%2B%20or%20-%20a%20number%20from%20a%20range%20of%20cells%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217045%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318573%22%20target%3D%22_blank%22%3E%40tlwarranties%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIF(%20B5%3D%22%22%2C%20%22%22%2C%20C4-B5%20)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217120%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20create%20a%20formula%20in%20one%20sheet%20to%20%2B%20or%20-%20a%20number%20from%20a%20range%20of%20cells%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217120%22%20slang%3D%22en-US%22%3EPERFECT!!!%20thank%20you%20so%20much%20for%20your%20help!%3C%2FLINGO-BODY%3E
New Contributor

I have a sheet (Sheet1) with a cell that has a # and I need that # to decrease or increase based on another sheet (Sheet2) range of cells.

4 Replies

@tlwarranties 

With your permission, I recommend to provide more information.

If possible, add a file (without sensitive data) and use this file to describe your issue/project step by step, or add photos with the appropriate description.

Please, always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

Don't forget that not every Excel user has a clue about every job and what you see he can't see.

 

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

@NikolinoDE  I figured that part out, thanks.  New question:  how do I stop a value from repeating when there is nothing in one of the cells i'm using in the formula?  Is there a way to make those either zeros or just blank?

 

 Untitled.png

best response confirmed by Hans Vogelaar (MVP)
PERFECT!!! thank you so much for your help!