title: In One cell Formula is working but not in Other
body: <p>I have pasted same formula in other cell. It is showing #value! Error.</p>
  
  <p>=SUM(MP_Report!Z:Z,IF(MP_Report!K:K,"EPIC"))</p>
  
  <p>I also tried control+shift+Enter in formula tab. It didnt work.</p>
  
  <p>Please help me on this</p>