Results 1 to 2 of 2

Thread: Array issues
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2015
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Array issues

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

  2. #2
    New Member
    Join Date
    Nov 2015
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Array issues

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •