unexpected formula error

DALE1612

New member
Joined
Sep 22, 2015
Messages
18
Reaction score
0
Points
0
Excel Version(s)
2007
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.
 

Attachments

  • PF v5.xlsx
    77 KB · Views: 10
Back
Top