title: Can you copy an array formula down without having to hit Ctrl+Shift+Enter?
body: <p>I tried a fix like under &quot;<a href="https://stackoverflow.com/questions/12526573/excel-array-formula-not-have-to-ctrl-shift-enter">excel array formula: not have to 'ctrl-shift-enter'?</a>&quot; Here's my formula:</p>
  <pre><code>=(0*0)+SUM(IF(A10=Bundle!$B$2:$B$58233,1/(COUNTIFS(Bundle!$B$2:$B$58233,A10,Bundle!$N$2:$N$58233,Bundle!$N$2:$N$58233)),0))
  </code></pre>
  <p>The &quot;before the fix&quot; formula works, but there are a lot of rows, and it would take a long time to <kbd>Ctrl</kbd> + <kbd>Shift</kbd> + <kbd>Enter</kbd> all 2624 times. I added the code as suggested and the <code>0*0</code> like above, but it didn't work.  Do I have to do something to activate the code?</p>
  <p>This and several other posts online suggest that array formulas will just fill-down, but that doesn't work either.</p>