Hey all, I'm just curious about something. Is there a way to input a formula that expands itself as more data is put in? For example, this data adds a group of numbers together:
=SUM(A1:A3)
=SUM A1+A2+A3
Is there a way for the code to update itself to include A4 if there is a value in A4? Thanks for the information.
Last edited by qcity; 06-12-2011 at 10:35 PM.
Why not just =SUM(A:A)
If you don't like that then try
=SUM(A1:INDEX(A:A,MATCH(9.99999999999999E+307,A:A)))
HTH
Regards, Jeff
Can't believe it was so simple. Thanks.
Glad to see it worked for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks