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.
77 KB Views: 6