For this little guy:
The only reason a simple =SUM(A2:A10000000000000) won't work is because too many lines are getting deleted with each update, and I'm trying to avoid having to check if pasted data falls outside of the SUM range every time. Any suggestions would be greatly appreciated.
Code:
[FONT=Arial]=SUM($A$2:INDEX(A:A,ROWS(A:A))[/FONT]<wbr style="font-family: Arial, Helvetica, sans-serif; font-size: small;">[FONT=Arial])[/FONT]The only reason a simple =SUM(A2:A10000000000000) won't work is because too many lines are getting deleted with each update, and I'm trying to avoid having to check if pasted data falls outside of the SUM range every time. Any suggestions would be greatly appreciated.
