A formula within a formula is not working

Copper 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.