If statement is true of specific range then formula execute

%3CLINGO-SUB%20id%3D%22lingo-sub-1786940%22%20slang%3D%22en-US%22%3EIf%20statement%20is%20true%20of%20specific%20range%20then%20formula%20execute%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1786940%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20get%20%22sum%22%20if%20a%20specific%20number%20exists%20in%20a%20range%20of%20the%20next%20sheet%20otherwise%20return%200.%20For%20example%2C%20if%20a%20specific%20value%20exits%20in%204%20columns%20then%20get%20a%20total%20of%204%20columns%2C%20and%20if%20there%20are%20no%20value%20exits%20then%20return%200.%26nbsp%3B%20I%20am%20sharing%20the%20sheet%20here%20and%20red%20highlighted%20cells%20having%20matching%20values%20and%20yellow%20highlighted%20cells%20where%20I%20need%20output.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1786940%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-1787720%22%20slang%3D%22en-US%22%3ERe%3A%20If%20statement%20is%20true%20of%20specific%20range%20then%20formula%20execute%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787720%22%20slang%3D%22en-US%22%3EIn%20cell%20H6%20you%20are%20getting%20ZERO%20because%20in%20entire%20Column%20A%20has%20FALSE%2C%2C%2C%20and%20getting%20answer%20in%20I6%2C%20J6%20%26amp%3B%20in%20K6%20because%20in%20Column%20B%2C%20C%20and%20in%20D%20has%20few%20TURE%20value.%20(%20in%20sheet%20GL).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1787930%22%20slang%3D%22en-US%22%3ERe%3A%20If%20statement%20is%20true%20of%20specific%20range%20then%20formula%20execute%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1787930%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3EYes!%20It%20is%20absolutely%20ok%2C%20but%20I%20want%20a%20formula%20by%20which%20I%20need%20%22sum%22%20only%20when%20%22c4%22%20cell%20in%20%22GL%22%20sheet%20matches%20with%20%22AA%202%22%20cell%20in%20%22Return%22%20sheet.%20if%20c4%20don't%20found%20any%20matches%20then%20return%200%20value.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I am trying to get "sum" if a specific number exists in a range of the next sheet otherwise return 0. For example, if a specific value exits in 4 columns then get a total of 4 columns, and if there are no value exits then return 0.  I am sharing the sheet here and red highlighted cells having matching values and yellow highlighted cells where I need output.

3 Replies
In cell H6 you are getting ZERO because in entire Column A has FALSE,,, and getting answer in I6, J6 & in K6 because in Column B, C and in D has few TURE value. ( in sheet GL).

@Rajesh-SYes! It is absolutely ok, but I want a formula by which I need "sum" only when "c4" cell in "GL" sheet matches with "AA 2" cell in "Return" sheet. if c4 don't found any matches then return 0 value.

In fact cell C4 of sheet GL was blank,,, now I've filled value/criteria and the formula is in H3,, just check the attached WB,, I do believe that this solves the issue.