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.
Best Answer
You can use either
OFFSET
, eitherINDIRECT
to refer the custom range:OFFSET(A5,0,0,ROWS(A:A)-ROW(A5)+1)
INDIRECT("A5:A"&ROWS(A:A))
Both result in a range from A5 to the bottom of the column.