• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Error in formula

Remember to follow all forum guidelines: Cross-posting
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.
Thank you...



Excel Ninja
derek davis
You should reread: