Array issues

[adamolivier]

I am using the following array formula in an Excel 2010. It works fine when I press CTRL+SHIFT+ENTER, however I noticed that the {} are not shown. When I close the workbook and reopen, I have to go back through and hit CTRL+SHIFT+ENTER again for it to calculate.

Is there a setting in Excel that could be causing this?

=SUM(IF(A2='Working Tract Schedule'!A2:A2006, 1/(COUNTIFS('Working Tract Schedule'!A2:A2006, A2, 'Working Tract Schedule'!B2:B2006, 'Working Tract Schedule'!B2:B2006)), 0))

 

[adamolivier]

This has been fixed.

The issue was that you cannot edit an array formula in a shared workbook. You must unshared the workbook, make you adjustments, then share again. All seems to work fine now.