A formula within a formula is not working

%3CLINGO-SUB%20id%3D%22lingo-sub-3175733%22%20slang%3D%22en-US%22%3EA%20formula%20within%20a%20formula%20is%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3175733%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20formulas%20in%20a%20workbook%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%26nbsp%3B%26nbsp%3B%3DIF(ISNUMBER(SEARCH(%24U%243%2C%24M4))%2C%221%22%2C%220%22)%3C%2FP%3E%3CP%3EThis%20returns%20either%20a%201%20or%20a%200%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%26nbsp%3B%3DIFERROR(SUMIF(dates%2C%24A3%2Cdemo)%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EResults%20of%20both%20formulas%20are%20formatted%20as%20numbers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20copy%20paste%20special%20the%20results%20of%20the%20first%20formula%2C%20then%20the%20second%20works.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20won't%20the%20second%20formula%20work%20with%20the%20first%20formula%20in%20the%20cell%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3175733%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-3175770%22%20slang%3D%22en-US%22%3ERe%3A%20A%20formula%20within%20a%20formula%20is%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3175770%22%20slang%3D%22en-US%22%3EI%20figured%20it%20out-%20It%20works%20when%20I%20remove%20the%20%22%22%20from%20the%20first%20formula.%3C%2FLINGO-BODY%3E
New Contributor

I have two formulas in a workbook

 

1.  =IF(ISNUMBER(SEARCH($U$3,$M4)),"1","0")

This returns either a 1 or a 0

 

2. =IFERROR(SUMIF(dates,$A3,demo),"")

 

Results of both formulas are formatted as numbers

 

If I copy paste special the results of the first formula, then the second works.

 

Why won't the second formula work with the first formula in the cell? 

Thank you

1 Reply
I figured it out- It works when I remove the "" from the first formula.