Results 1 to 3 of 3

Thread: unexpected formula error

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Seeker DALE1612's Avatar
    Join Date
    Sep 2015
    Excel Version

    unexpected formula error

    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

Posting Permissions

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