adamolivier
New Member
- Joined
- Nov 18, 2015
- Messages
- 6
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))
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))