Exclude a cell again

[DF2507]

Thx that will help with part of my problem but how would I make A16
variable.........for instance.....the last cell I enter could be A17 not A16
but I don't want to keep going back to my formula to amend it........

 

[Don Guillett]

one way where you are looking for a number larger than possible in your
column.
=SUM(INDIRECT("a2:a"&MATCH(9999999,a:a)))

 

[Ragdyer]

It's really best to stay with your original thread.
This prevents others who wish to help from duplicating already suggested
solutions.

http://tinyurl.com/j74o3