Results 1 to 3 of 3

Thread: unexpected formula error

  1. #1
    Seeker DALE1612's Avatar
    Join Date
    Sep 2015
    Posts
    18
    Articles
    0
    Excel Version
    2007

    unexpected formula error



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello experts could you help me? if you take a look at the example sheet att: colunm R have formula that I can't seem to automaticaly expand. Here is part of the formula that I am concerned about ((A$3:A103)+(F$3:F103)+(J$3:J103 when I set 103 to a high value I get a N/A error. Colunms A,F,J will need to continue to grow so I can't predefine the the end value. I don't know if there is a way to overcome this issue. Any advise would be appreciated.
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,585
    Articles
    0
    Excel Version
    365
    cross posted without links:
    https://chandoo.org/forum/threads/er...formula.42355/
    DALE1612, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

  3. #3

Posting Permissions

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