CODEWITHSUNDEEP
arraysexcel
John Nesbit
John Nesbit

Reputation: 11

Can you copy an array formula down without having to hit Ctrl+Shift+Enter?

I tried a fix like under "excel array formula: not have to 'ctrl-shift-enter'?" Here's my formula:

=(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))

The "before the fix" formula works, but there are a lot of rows, and it would take a long time to Ctrl + Shift + Enter all 2624 times. I added the code as suggested and the 0*0 like above, but it didn't work. Do I have to do something to activate the code?

This and several other posts online suggest that array formulas will just fill-down, but that doesn't work either.

Upvotes: 1

Views: 18305

Answers (1)

rwilson
rwilson

Reputation: 2145

If the array formula is in cell B2, and you want to copy and paste the formula to cells B3:B10, you can ONLY paste the formulas to cells B3:B10. You can't include cell B2 when you paste the formulas or you will get a "you cannot change part of an array" error message.

Upvotes: 2

Related Questions