I am looking to do summary statistics on a column of varying lengths.
I want to do something like
=sum(A:A) except I want to avoid the first 5 rows of column A. Is there a way to do it?
EDIT: Someone pointed out a possible duplicate. Except neither of the solutions in that question actually works. If someone is proposing to apply
ISBLANK() to the whole column until the maximum index, I would like to see clarification on the different between that and formats such as
A:A -- in terms of speed.