Excluding only leading or trailing cells from a column

P

PaladinWhite

I have a column, say A, that I want to SUM(). I want to avoid including A1:A3
in this sum - unfortunately, the length of the data in the column at any time
is indeterminate. So I can't SUM(A4:AX)... And I can't SUM(A4:A), although
that seems intuitive to me.

Help?
 
T

T. Valko

Re: Excluding only leading or trailing cells from a column

You've explained about excluding the leading cells A1:A3 but what do you
mean when you say exclude trailing cells? What trailing cells?
 
P

PaladinWhite

D'oh - I can't believe something that simple eluded my grasp. That's
precisely what I need to do. Thanks.
 
P

PaladinWhite

Sorry, I guess the title was a bit misleading. The "or trailing" part was
simply tacked on because I initially thought the solution would probably be
similar whether the cells to be excluded were leading or trailing - now that
I think about it, if I needed to exclude trailing cells, I would already know
the length of the data column, and I could just use SUM(A1:AX).
 
Top