Excel not showing formula result on sheet, but F9 shows correct value
<p>I'm working on an excel sheet and I've encountered an issue I've never come across before. I'm trying to sum the results of an array function, but I'm not getting any results from the sum on the sheet - just blank cells. The weird part is when I press <kbd>F9</kbd> in the formula bar it shows the correct summed value that should show in the cells on the sheet. I just don't get why the value would appear in the formula bar, but not in the cells on the sheet. Other forums mentioned changing the calculation option (on automatic of course) or to 'show zeros', which just changed the cells to zero instead of blank. <kbd>F9</kbd> still shows the correct value. Here's the formula:</p>

<pre><code>{=SUM(OFFSET(INDIRECT("Sheet1!E"&amp;IF(ISERROR(MATCH($A$2:$A$15&amp;$C$1,Sheet1!$C$2:$C$51,0)),
1000,MATCH($A$2:$A$15&amp;$C$1,Sheet1!$C$2:$C$51,0))),0,ROW(1:1)))}
</code></pre>

<p>The match gets me the row index for the numbers I need to sum. (E1000 is just a default for when there isn't a match and references a cell with 0 in it). If I remove the sum from the function and use <kbd>F9</kbd> I can see the actual array with the numbers to be summed. This is what is so confusing to me. Everything seems to evaluate correctly, it just doesn't show on the sheet. Thanks for the help!</p>