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.
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_SinhaYes! 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.
