The behaviour of selecting the bottom values of a given column does not seem fully functional.

SUM(A2:A) works but it does not highlight the cells to which the formula is applied and so it does not feel fully functional. Which might be the case because locking the values to SUM($A$2:$A) throws the error "#REF! Circular dependency detected".

This functionality is available in Google Sheets.